Custom Toolbar

G

GoogleGirl

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?
 
J

Jim Rech

CommandBars("MyCustomToolbar").Controls("MyMenu").Controls("Button1").OnAction
= "MyMacro"

--
Jim
| 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?
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet toolbar 6
Ribbon - custom button calls macro with argument 5
Can't get Control.State to work 15
Initiating a Custom Toolbar 0
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Macros I want dont appear in the customise box to drag to a toolbar 1
Initializing a custom toolbar 3
Excel 2007 "Custom Toolbars Button" 2

Top