How do I hide/unhide commands on my custom tool bar from VBA?
J Jeff Conrad Apr 6, 2006 #2 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 My menu bar is called SwitchboardMenu. Under the Tools menu on the 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:
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 My menu bar is called SwitchboardMenu. Under the Tools menu on the 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:
