Thread
:
CommandBars & Custom
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary Brown
external usenet poster
Posts: 178
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 With Quote
Gary Brown
View Public Profile
Find all posts by Gary Brown