Okay, I have a fairly complex workbook that contains many, excrutiatingly long formulas. Now, this workbook is used by many other people in my department to record hours charged to specific accounts. I do not use the 'share workbook' function as I do not see its uses necessary. However, there are certain cells in this workbook that I want protected, as they contain the long formulas. I can protect each sheet and each cell I want no problem. I use go through Tools, Protection, and then Protect Sheet. Now, here's the problem. I have multiple sheets within this workbook and I want to change information within the cells that I have protected. How can unprotect these cells without going to each and every sheet to do so. I cannot select them as a group and unprotect. Excel will not let me. If I protect everything as a workbook, and not worksheet, I cannot protect those individual cells! Is there anyway to do this!?!?!? Please help!!!!!!!!

Jenni, I've been thinking about this situation ever since you posted. What if you set up your file so that it will not allow certain users to edit cells in a range? Wouldn't that protect your formulas?

Try this:
Open your workbook and go to your protected worksheets.
On the Tools menu, go to Protection and then click Unprotect Sheet
On the Tools menu, go to Protection, and then click Allow Users to Edit Ranges.

Now you can set it so that you allow only certain people to edit a range.
In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the users.
Click Modify, and then click Permissions.
Do one or more of the following:
To block a user temporarily from editing the range, click the user in the Name list, and then select the Deny check box for the user.
To unblock a user, click the user in the Name list, and then select the Allow check box for the user.
To remove a user permanently, click the user in the Name list, and then click Remove.
To add a new user, click Add, locate and select the new user, click Add, and then click OK.
Click OK, and if prompted about denying users click Yes, and then click OK again.

To change the cells you want to include in a range:
In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the included cells.
Click Modify.
In the Refers to cells box, type or select the new range, and then click OK.

When you are finished making changes in the Allow Users to Edit Ranges dialog box, click OK.

Thanks Georgia. Once I realized I needed to password protect those certain cells and then protect the sheet, it worked perfectly. Thanks for all your help!

Kewl! Glad you figured it out

What you suggested worked perfect once I did put the password on there. It's going to be a long process to do it to about 3 dozen sheets and give permissions to about 20 users, but at least I'll only have to do it once! Couldn't have done it without you! Thanks a bunch!