Microsoft Office Tutorials and References
In Depth Information
Protect a Workbook’s Windows and Structure
Protect a Workbook’s
Windows and Structure
You can prevent unwanted changes to a
workbook by activating protection for the
workbook’s windows and structure.
When you activate protection for windows,
Excel takes the following actions:
It hides the window’s Close, Maximize, and
Minimize buttons. If the workbook is not
maximized, Excel also disables the window
borders. This means the window cannot be
moved, sized, or closed.
It disables the View tab’s New Window, Split,
Freeze Panes, and View Side By Side
commands when the window is active. The
Arrange All command remains active, but it has
no effect on the protected window. The Hide
and Unhide commands remain active.
When you protect a workbook’s structure,
Excel takes the following actions:
It disables most sheet-related commands,
including Insert Sheet, Delete Sheet, Rename
Sheet, Move or Copy Sheet, Tab Color, Hide
Sheet, and Unhide Sheet.
It prevents the Scenario Manager from creating
a summary report.
1 Display the workbook
you want to protect.
2 Click the Review tab.
3 Click Protect Workbook.
2
3
1
The Protect Structure and
Windows dialog box
appears.
4 Click to select the
Structure check box to
protect the workbook’s
structure.
5 Click to select the
Windows check box to
protect the workbook’s
windows.
6 Type a password in the
Password text box, if
required.
7 Click OK.
5
6
7
 
Search JabSto ::




Custom Search