formatting in a protected sheet

[Guest]

Hello,
I have a sheet in which I want to protect certain cells
from being changed. However, when I enable protection,
cell formatting is blocked for the entire sheet, not only
the cells that are marked as protected. Is there a way
around this??

-rjs

 

[Frank Kabel]

Hi
depending on your excel version (I think starting with Excel 2002) you
can enable formating in the Protection dialog

 

[Guest]

Ok, I guess I need to upgrade then! Any ideas for a work
around in Excel 2000?

-rjs

 

[Ron de Bruin]

Hi rjs

If you can use a macro it is possible do your formatting
Is that a option for you?

 

[Silas]

I'm still using Excel 97 but I believe this will work in 2000 also.

All you have to do is "unlock" the cells you want access to before you
protect the worksheet, as follows:

1. Select the cells you want to be able to edit.
2. Right-click the selection and choose Format Cells from the shortcut menu.
3. Click the Protection tab.
4. Turn off the option called Locked. (Cells are locked by default; that's
why you don't have to lock the other cells.)
5. Click OK.
6. Choose Tools + Protection + Protect Sheet.
7. Make sure Contents is selected.
8. In the Password box, type a password.
9. Click OK; in the box that appears, retype the password, and click OK.

Now anyone can change the unprotected cells, but only those who know
the password can edit your protected cells. I hope this works for you.

silas