DISABLE RENAMING WORKSHEETS EXCEL 2003 / 2007

IF you are creating reports in Excel, which need to be edited by someone else, you might want to make sure that they do not change the worksheet names.

Carry out the following steps to do so in Excel 2003:

• Open the workbook.
• Go to the 'Tools | Protection | Protect Workbook'.
• Select the 'Structure' option in the 'Protect Workbook' dialog box.
• Type in a password in the 'Password' text box.
• Retype the password to secure the workbook.

If you plan to use Excel 2007 instead, follow these steps:

• Go to the 'Review' tab.
• Click the 'Protect Workbook' option appearing under the 'Changes' group of the tab.
• Click the 'Protect Structure and Windows' option from the dropdown list.
• Select the 'Structure' option in 'Protect Workbook' dialog box.
• Type a password in the 'Password' text box.
• Retype the password to secure the workbook.

Once protected, other users cannot change the names of the worksheet tabs, nor can they create new worksheets or delete existing ones without the password.