Protect a Workbook

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference > Spreadsheet > Protection >

Protect a Workbook

Interface Elements for Desktop > Spreadsheet > Protect a Workbook

Workbook protection prevents users from changing a workbook’s structure (by moving, deleting, adding, hiding or displaying a hidden worksheet) or window position (by freezing or unfreezing panes).

You can protect a worksheet by using the following dialog:

img23283

To invoke this dialog, on the Review tab, in the Changes group, click Protect Workbook.

img23281

In a protected workbook, this button displays the "Unprotect Workbook" caption, which invokes a simple dialog that prompts for a password or unlocks the workbook if an empty password was set.

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.