DoCmd.LockNavigationPane method (Access)

You can use the LockNavigationPane method to prevent users from deleting database objects that are displayed in the navigation pane.


expression.LockNavigationPane (Lock)

expression A variable that represents a DoCmd object.


Name Required/Optional Data type Description
Lock Required Variant Set to True to lock the navigation pane.


Locking the navigation pane prevents the user from deleting database objects or cutting database objects to the clipboard. It does not prevent the user from performing any of the following operations:

  • Copying database objects to the clipboard.

  • Pasting database objects from the clipboard.

  • Displaying or hiding the navigation pane.

  • Selecting different navigation pane organization schemes.

  • Showing or hiding sections of the navigation pane.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.