Customizing context menus - Microsoft Community
- Get link
- X
- Other Apps
hi,
referring thread: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom-mso_2013_release/customizing-context-menu/207a7216-5c6f-49d1-9b9d-74bedb45c410
<ribbon startfromscratch="false" >
<tabs >
<tab
id="jpe_extension"
label="jp's extension"
tag="public"
visible="true">
<!--data cleaning-->
<group
id="jpdatacleaning"
label="data cleaning"
tag="data_cleaning"
autoscale="true">
<button
id="jpe_trimnonbreakingspace"
imagemso="eraserlastused"
label="non-br. sp"
screentip="remove non-breaking space asc(160)"
supertip="non-breaking spaces used in htm pages , cannot been removed trim function"
tag="data_cleaning_nonbreakingspace"
getenabled="jpe_getenabled"
onaction="jpe_datacleaning_onaction"/>
trying make available in de cellmenu, added:
<contextmenus>
<contextmenu idmso="contextmenucell">
<button
id="jpe_trimnonbreakingspacecm"
imagemso="eraserlastused"
label="non-br. sp"
onaction="jpe_datacleaning_onaction"/>
</contextmenu>
</contextmenus>
i have macro called ribbon button:
sub jpe_datacleaning(blnfullcleaning boolean)
but cannot call form rightclick menu, idea? macro not exist or macros have been disabled. working tab/group/button. should not reason. tried several options onaction without success. reading.
the sub in wrong format, try:
sub jpe_datacleaning(control iribboncontrol)
andreas.
Office / Excel / Windows other / Office 2013
- Get link
- X
- Other Apps
Comments
Post a Comment