Link to home
Start Free TrialLog in
Avatar of adamdaban daban
adamdaban daban

asked on

Hiding Queries by VBA

Hello everyone, I use this code for hiding Queries   [   Application.SetHiddenAttribute 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?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

<<did there is another VBA code to hide all my queries and can show again by VBA again?>>

 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.
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
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of adamdaban daban
adamdaban daban

ASKER

Thanks for all of you and excellent advice