Protect a Workbook

<< Click to Display Table of Contents >>

Navigation:  User Interface (UI) Elements > Spreadsheet >

Protect a Workbook

 

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:

SSPW1

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

SSPW2

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