Disabling menu options in a Custom Menu

[VBAgroupie]

Hello. Is there a way to disable certain menu options in a custom menu?
Depending upon the certain conditions I would like some options to show up
while others don't (grayed out). Is my only option is to have several menus?
Thanks.

 

[Jeff Conrad]

Here is a past post of mine which should help:
What you need to do is "walk-down" the command bars controls collection.

Here is an example:
CommandBars("SwitchboardMenu").Controls("Tools").Controls("Administration").Enabled = False

The menu bar is SwitchboardMenu.
Under the Tools menu on my SwitchboardMenu I am disabling the Administration option.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[VBAgroupie]

Thank you both for the answer! It is much appreciated.

 

[Jeff Conrad]

You're welcome, glad to help.
Good luck with your project.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: