Hi How can I disable or hide a menu item via vba? Thanks Regards
J Jeff Conrad Aug 22, 2005 #2 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 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:
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 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:
