Protecting Worksheets And Workbooks In Excel 2003

By Claire Jarrett

Protecting worksheets and workbooks in Excel 2003 can be especially important if you plan to share the document with other people. You can prevent accidental changes to the content, layout, and formulas included in a workbook by protecting worksheets and workbooks. It's important to choose the right level of protection to provide access to the data and worksheet functions without unnecessary interference.

When you want to prevent changes to the workbook itself, you should protect the entire workbook. This will eliminate the accidental or unwanted insertion or deletion of workbook page; the renaming of individual sheets within the workbook; the hiding and unhiding of work sheets; size and shape changes within workbook windows; copying or moving of worksheet pages; splitting and unsplitting, and freezing and unfreezing of window panes within a worksheet.

To protect a workbook, choose Tools > Protection > Protect Workbook. The Protect Workbook dialogue box will appear. Select the type of protection you want - Structure or Windows. (You may select both to lock the workbook completely). You may add a password if you choose. If you do not add a password, any user can remove the protections you have specified. Select OK. The workbook and all subsequent copies of it will be protected.

If you simply want to protect formulae, objects and scenario definitions created on a specific worksheet, you should protect the worksheet you're interested in preserving. To protect a worksheet in Excel 2003, select Tools > Protection > Protect Sheet. From the Protect Sheet dialogue box, choose the types of protection you're looking for. The dialogue box provides checkbox to protect the sheet, as well as a list of optional allowed actions. You may add a password to the worksheet. If you do not add a password, any user can change the protections you've specified. When you are finished, click OK. The worksheet will be protected.

To unprotect a password protected workbook or worksheet, you must have the password, if one was assigned. Select Tools > Protection > Unprotect Workbook, or Tools > Protection > Unprotect Worksheet. Enter the password and click OK.

Claire Blinman is the training manager at Computer Training Solutions in Bristol. Computer Training Solutions offer Excel training courses or call 0800 019 6882