lock only formulas, not worksheet
 

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?

lock only formulas, not worksheet
 

Which version of Excel?

In 2002 and 2003 you can allow or disallow things in ToolsProtectionProtect
Sheet.

Format Cells, Insert/delete rows and columns.


Gord Dibben MS Excel MVP

On Fri, 18 Jan 2008 09:20:00 -0800, ericaamousseau
wrote:

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?

lock only formulas, not worksheet
 

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

On Jan 18, 5:20*pm, ericaamousseau
wrote:
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? *