You can prevent a workbook from having its structure and windows modified or resized by another user. The Protect Workbook dialog box appears. This includes adding or deleting worksheets. The workbook is protected. The workbook is unprotected.
Users can now modify the structure and windows of the workbook.
If you included a password when you turned the protection on, you must enter the password to turn the protection off. Worksheet Level Protection You can protect a single worksheet from being modified by another user. The Protect Sheet dialog box appears. The worksheet is protected. The worksheet is unprotected.