View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default 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