LockNavigationPane Macro Action

You can use the LockNavigationPane macro action in Access desktop databases to prevent users from deleting database objects that are displayed in the Navigation Pane.

Note: The LockNavigationPane macro action isn't available in Access web apps.

Setting

The LockNavigationPane macro action has the following argument.

Action argument

Description

Lock

Select Yes to lock the Navigation Pane, or No to unlock the Navigation Pane.

Remarks

Locking the Navigation Pane prevents you from deleting database objects or cutting database objects to the clipboard. It does not prevent you 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

To run the LockNavigationPane action in a VBA module, use the LockNavigationPane method of the DoCmd object.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×