This article will explain how to hide and unhide the navigation pane in an Access database using VBA.

Hide:

The following code will hide the navigation pane:

'select the navigation pange
Call DoCmd.NavigateTo("acNavigationCategoryObjectType")
'hide the selected object
Call DoCmd.RunCommand(acCmdWindowHide)


Before:

After:

Unhide:

The following code will bring the navigation pane back:

Call DoCmd.SelectObject(acTable, , True)


See also:

• Hide/Unhide Access Ribbons, VBA

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com