Friday, February 03, 2006
Sometimes, you may want to protect an Excel workbook by preventing users from adding or deleting sheets. Or, you may want to ensure that the workbook's window size or position is not changed. Here's how:
Choose the Tools, Protection, Protect Workbook command to display the following dialog box.
Choose the appropriate option and click OK.
Structure prevents any of the following changes to a workbook: Adding a sheet, deleting a sheet, moving a sheet, renaming a sheet, hiding a sheet, or unhiding a sheet.
Windows protects the workbook window from being moved or resized.
You can supply a password or not, depending on the level of protection you need.
To remove protection from a protected workbook, choose the Tools, Protection, Unprotect Workbook command.
Choose the Tools, Protection, Protect Workbook command to display the following dialog box.
Choose the appropriate option and click OK.
Structure prevents any of the following changes to a workbook: Adding a sheet, deleting a sheet, moving a sheet, renaming a sheet, hiding a sheet, or unhiding a sheet.
Windows protects the workbook window from being moved or resized.
You can supply a password or not, depending on the level of protection you need.
To remove protection from a protected workbook, choose the Tools, Protection, Unprotect Workbook command.
