ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Toolbar (https://www.excelbanter.com/excel-programming/377755-custom-toolbar.html)

GoogleGirl

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?


Jim Rech

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