Toolbar Question (Self Resolved)

[Avatarp]

I have a custom toolbar I design in Excel. It has 1 Menu button on it with many buttons within that1 menu button. How would I ghost out 1 of those buttons that are underneith that menu button?

[opus]

Set the .ENABLED to FALSE.

[Avatarp]

Set MyControl = CommandBars("ButtonTest").Controls(1)
Set Ctrl1 = MyControl.Controls(3)
Ctrl1.Enabled = False


Assuming the toolbar name is ButtonTest and there is only 1 menu button with atleast 3 buttons in the sub menu.


But thanks opus for your insite, very valuable information there buddy