CommandBars & Custom

[John JBM]

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 Doesn’t ?application.Commandbars("Custom
Menu").Controls.Item(1).Caption

Any ideas?

 

[Gary Brown]

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
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.