View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ericaamousseau ericaamousseau is offline
external usenet poster
 
Posts: 19
Default 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?