Run macro from toolbar button

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   A user recently sent an email asking if it is possible to run a macro from a custom toolbar button. Here is the response:

Yes, you
can add a macro to a toolbar button. I don’t think
the syntax to run a macro from a toolbar button has been documented, and it
took me a while to sort it out. 

Create and test your
     macro. 
If you don't remember your macro name, you can use Tools -> Macro -> Edit Macros. This opens the
     script editor, with the Macro tab selected. Each macro begins with Sub and
     ends with End Sub. At the beginning of each macro are comments with the macro
     name, shortcut and description. You can edit any of these to change the macro name, description or shortcut. After
     modifying the macro, use File->Save from the script editor window to
     save the changes.
Open the menu designer
     from the Tools menu. Expand the Toolbar node. Click on the main Toolbar
     item. At the bottom, click the New button and select “normal button”. 
When the new button
     properties panel opens, add a tooltip if you want, and click Select Image
     to select an icon for the button.
In the Action field,
     enter [#2999#NameOfYourMacro]. The square brackets [ ] are important.
This causes the menu
     processor to execute the built-in command 2999, which is the value of the MACRO_RUN_LAST built-in constant. Since 2999 is in the
     range of MACRO_RUN_FIRST (2000) to MACRO_RUN_LAST (2999), the macro name after the 2^nd
     “#” will be the name of the macro to execute. If you have multiple toolbar
     button macros, you could use 2998, 2997, etc. as the ID after the first “#”.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
PSchellenbach Members Profile Find Members Posts Admin Group Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150	Post Options Post Reply Quote PSchellenbach Report Post Thanks(0) Quote Reply Topic: Run macro from toolbar button Posted: October 19 2021 at 4:03pm
	A user recently sent an email asking if it is possible to run a macro from a custom toolbar button. Here is the response: Yes, you can add a macro to a toolbar button. I don’t think the syntax to run a macro from a toolbar button has been documented, and it took me a while to sort it out. Create and test your macro. If you don't remember your macro name, you can use Tools -> Macro -> Edit Macros. This opens the script editor, with the Macro tab selected. Each macro begins with Sub and ends with End Sub. At the beginning of each macro are comments with the macro name, shortcut and description. You can edit any of these to change the macro name, description or shortcut. After modifying the macro, use File->Save from the script editor window to save the changes. Open the menu designer from the Tools menu. Expand the Toolbar node. Click on the main Toolbar item. At the bottom, click the New button and select “normal button”. When the new button properties panel opens, add a tooltip if you want, and click Select Image to select an icon for the button. In the Action field, enter [#2999#NameOfYourMacro]. The square brackets [ ] are important. This causes the menu processor to execute the built-in command 2999, which is the value of the MACRO_RUN_LAST built-in constant. Since 2999 is in the range of MACRO_RUN_FIRST (2000) to MACRO_RUN_LAST (2999), the macro name after the 2^nd “#” will be the name of the macro to execute. If you have multiple toolbar button macros, you could use 2998, 2997, etc. as the ID after the first “#”.