I’ve inherited an LO calc spreadsheet which has a custom menu. I need to find out which macro is called when a menu item is selected. I can assign a macro to an event, but I can’t see any way of finding which one is already assigned in the IDE. Any pointers, or do I have to set a breakpoint in every possible macro and see which one happens?
When a macro is assigned to a custom menu the name of the macro is set in the menu. That name can be changed to perhaps a more descriptive name so the name of the macro is no longer shown.
If you open the LO Calc file with an archive program and select the Configurations folder and then the menubar folder there will be menubar.xml. If you view this xml you will see entries showing “menu:id=”.uno:AddDirect"/>
" followed by something like "menu:id=“vnd.sun.star.script:Standard.Module1.Vmade?” where Vmade is the macro name in this case. This will be followed by something like “language=Basic&location=application” menu:label=“TestM”/>
" where TestM is the name in the Menu.
Thanks very much - that worked fine and saved me a load of debugging.