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?
|