It's been a while since I noted the security problem with displaying the Navigation Pane for all users. I looked for solution but it was hard to find, mostly complex codes were suggested.
But since there is kind of a need for it at work, I looked it up again and found that it's not that hard to disable/hide the navigation pane. Including disabling the shortcut key to open the navigation pane - F11.
Hiding the Navigation Pane - two ways.
- By code:
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide - From option menu:
Access Options -> Current Database -> Navigation -> Display Navigation Pane -> (Uncheck it)
The users have an alternative to open Navigation Pane with F11. So, the trick to disable it is assigning F11 to something else, such as Beep action. To make it a global (otherwise the solution must be implemented in every forms, etc.) effect, it has to be done in macro, not VBA scripting. To create such macro, under Create Tab -> Macro -> macro name = {F11} -> Action = beep. Save it as something like AutoKeys.
Note: {} means function key. +{F11} means shift-F11, ^{F11} means cntrl-F11.
This saved macro appears to only be accessible in the Navigation Pane.