![]() |
Custom Toolbar
am trying to assign a macro to a Button on a custom toolbar.
The following works: CommandBars("MyCustomToolbar").Controls("Button1") .OnAction = "MyMacro" But, I can't figure out how to assign a macro to a button on a custom toolbar that is in a "Group" (or submenu) on the Custom toolbar. Can you please help? |
Custom Toolbar
CommandBars("MyCustomToolbar").Controls("MyMenu"). Controls("Button1").OnAction
= "MyMacro" -- Jim "GoogleGirl" wrote in message oups.com... | am trying to assign a macro to a Button on a custom toolbar. | | The following works: | | | CommandBars("MyCustomToolbar").Controls("Button1") .OnAction = "MyMacro" | | | | But, I can't figure out how to assign a macro to a button on a custom | toolbar that is in a "Group" (or submenu) on the Custom toolbar. | | | Can you please help? | |
All times are GMT +1. The time now is 04:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com