Help with CommandBars

[Tim]

I have created a custom Menu Bar and am trying to write
code to disable/enable one of the menus.

I think I need to use the CommandBars functionality but
I'm not sure how; can anyone assist?

 

[Tim]

Panic over - I've found the answer. For anyone interested
I had to include a new reference (Microsoft Office 9.0
Object Library) and I then used the following code, which
works a treat.

CommandBars("Name of Menu Bar").Controls("Name of
Menu").Enabled = False

Hope this helps some-one else.