Customizing context menus - Microsoft Community


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&apos;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



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community