View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default how do I lock formulas, but still allow rows to be added or delet.

Tools Protection Protect Sheet
Then, choose what you want the user to do or not do.


Regards,
Ryan--


--
RyGuy


"ericaamousseau" wrote:

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row height.
Any suggestions?