Toolbar Question (Self Resolved)

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?

Set the .ENABLED to FALSE.

Code:

---

   
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