adamdaban daban
asked on
Hiding Queries by VBA
Hello everyone, I use this code for hiding Queries [ Application.SetHiddenAttri bute acQuery, "MyQuery", True ] but the problem is when I right click I can show all object hiding then I can see again, did there is another VBA code to hide all my queries and can show again by VBA again?
Most people will create a user form to act as a menu, or simply use the ribbon, and then hide the navigation pane entirely. The navigation pane in my opinion is only really for the developer.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all of you and excellent advice
No, there really is no way to do that. If you really want to hide things, you can create the querydefs in code, then delete the querydefs when your done.
Jim.