I want to activate this option with vba code so I can show and hide some hidden tables forms modules etc. I hide some things so users are not tempted to play but I want to make them available to some users but hidden from others.
Thanks
Norm
If you don't mind making a New tool menu
then you can call it from VBA using using Send keys
here is my code
SendKeys "%{N}", True 'Click on New menu Alt-N
SendKeys "O", True 'Click on Autoform under new menu
I created a new menu next to File, Edit, View, which I just left as "New menu"
I made the N underscore so I could get it with send keys
Next while in the menu design mode I drug a copy of the AutoForm menu item from the Insert menu over and gave it Underscore "O". When you drag over an existing menu item it retains the functionality from where it came.
That would work but sendkeys is messy and sometimes the keys can be sent to the wrong menu/object and sometimes even to the wrong application if the user happens to alt tab or something during the running of the code. I would expect to find some property that could be set with a simple command from within vba.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.