Protect Workbook in MS Excel





By Protecting a workbook, you can prevent users from Inserting, Modifying, Moving, Copying, Deleting, Renaming, Hiding and Unhiding sheets in the workbook.
Earlier we read Read : Protect Worksheet in MS Excel.

How to Protect Workbook in MS Excel
Let's learn with Example
>> Select and open the workbook you want to Protect.
>> Click Review tab and then Click Protect Workbook.
>> Click Protect Structure and Windows
>> Check Structure, enter a password and then click OK.
>> Re-Enter password and click OK.
Your Excel Workbook is now protected.
>> Users cannot Insert, Modify, Move, Copy, Delete, Rename, Hide and Unhide sheets in the workbook.
Let's see with Example
Users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.
To Unprotect the Workbook, Click Protect Workbook & Enter the Password you entered for Protecting the Workbook.
Also Read, How to Protect Worksheet in Ms Excel in  MS Excel tutorials for you :)

Labels: MS Excel
Must read for you :