View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?