Thread: Custom Toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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?
|