Tip Printed from ExcelTip.com

---

Protecting a Workbook


Why it is important to protect a workbook:

* To prevent the structure from being changed.
* To prevent sheets from being deleted.
* To prevent new sheets from being inserted.
* To prevent hidden sheets from being opened.

To protect a workbook:

1. From the Tools menu, select Protection and then Protect Workbook.
2. Type a password in the Password box, and click OK.
3. Confirm the password, and click OK again.