Microsoft Office Tutorials and References
In Depth Information
Protect a Workbook’s Structure
Collaborating with Others
If you specified a password,
Excel asks you to confirm it.
7 Type the password.
8 Click OK.
A Excel disables most
worksheetrelated commands on the
B Excel disables most
on the worksheet shortcut
What happens when I protect a
Excel disables most worksheet-related
commands, including Insert Sheet,
Delete Sheet, Rename Sheet, Move or
Copy Sheet, Tab Color, Hide Sheet,
and Unhide Sheet. Excel also prevents
the Scenario Manager from creating a
How do I remove workbook structure
If you no longer require your workbook
structure to be protected, you can
remove the protection by following Steps
to . If you protected your workbook 3
with a password, type the password and
then click OK. Excel removes the
workbook’s structure protection.