How do I protect a Workbook on Excel 2007?

Hi,
I have a workbook with plenty of worksheets with locked and unlocked cells. I want to lock the workbook, but NOT just for the layout or the windows, but for the content. I tried the "Protect Workbook" option, but this doesn´t protect my cells. This option still allows me to change locked cells. Older versions of Excel will also protect locked cells when you protected the workbook. I don´t want to have to enter a password for each worksheet in order to protect the cells. Can I do this, or is this another backward step in the Office 2007 package? Sorry for the frustration!

Thanks.

Protect worksheet or workbook elements

When you share a workbook with other users, you may want to protect data in specific worksheet or workbook elements to help prevent it from being changed. You can also specify a password that users must enter to modify specific, protected worksheet and workbook elements. In addition, you can prevent users from changing the structure of a worksheet.

Protecting worksheet elements
By default, when you protect a worksheet, all the cells on the worksheet are locked, and users cannot make any changes to a locked cell. For example, they cannot insert, modify, delete, or format data in a locked cell. However, you can specify which elements users will be able to change when you protect the worksheet.

Check Complete Procedure at This Page

Protect a Worksheet in Excel 2007

Open an Excel file to protect.

Click on the Home tab.

Choose the Format option on the ribbon to open the drop down list.

Click on Protect Sheet option at the bottom of the list to open the Protect Sheet dialog box.

This dialog box contains a number of options when protecting the worksheet.

The first option is to add a password to prevent worksheet protection from being turned off. This password does not stop users from opening the worksheet and viewing the contents.

Next there a number of options that can be turned on or off with check boxes. The first two allow a user to drag select locked and unlocked cells. If these two are turned off, users will not be able to make any changes to a worksheet - even if it contains unlocked cells.

The remaining options allow users to carry out specific tasks on a protected worksheet, such as formatting cells and sorting data.

When you have selected apropriate option click ok.

Unlocking a protected sheet

Click on the Home tab.


Choose the Format option on the ribbon to open the drop down list.


Click on Unprotect Sheet option at the bottom of the list.

I hope this helps you.

THANK YOU