lock only formulas, not worksheet

[ericaamousseau]

I am making a very complex spreadsheet for a co worker and I would like only
the formulas to be locked. I would like my co worker to still be able to
change the color of cells and add or delete rows (even rows thathave my
formulas) When I do protect the worksheet the way I usually do it rows can
not be adjusted at all. any suggestions?

 

[Gord Dibben]

Which version of Excel?

In 2002 and 2003 you can allow or disallow things in Tools>Protection>Protect
Sheet.

Format Cells, Insert/delete rows and columns.


Gord Dibben MS Excel MVP

 

[Pete_UK]

Before applying the protection, you must first unlock the cells which
you want the User to be able to adjust (using Format | Cells |
Protection tab). Then when you use Tools | Protection only the
remaining Locked cells will be affected.

If you are using XL 2000 then once the sheet is protected you can not
add or delete rows.

Hope this helps.

Pete