Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars & Custom
I'm trying to change the FaceID of a custom button on a custom mene. I can
access the buttons on built in commandbars but not the custom menu as shown below: This works: ?application.Commandbars("Format").Controls.Item(1 ).Caption This Doesnt ?application.Commandbars("Custom Menu").Controls.Item(1).Caption Any ideas? -- John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars & Custom
Check spelling and spacing of your custom commandbar.
Remember that the commandbar name may be different than what you're seeing on the screen. I have a commandbar called 'Amigo'. I just tried both... ?application.Commandbars("Amigo").Controls.Item(1) .Caption and ?application.Commandbars("amigo").Controls.Item(1) .Caption They worked perfectly. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "John JBM" wrote: I'm trying to change the FaceID of a custom button on a custom mene. I can access the buttons on built in commandbars but not the custom menu as shown below: This works: ?application.Commandbars("Format").Controls.Item(1 ).Caption This Doesnt ?application.Commandbars("Custom Menu").Controls.Item(1).Caption Any ideas? -- John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandBars vs CommandBars(1).Controls | Excel Programming | |||
Bulk-Delete All Custom Commandbars | Excel Programming | |||
Prob: Custom CommandBars and .xls Files Being Re-Opened | Excel Programming | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
Question on custom commandbars | Excel Programming |