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

xl2002, actually.

Bernard Liengme wrote:

I think this requires XL 2003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ryguy7272" wrote in message
...
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?


--

Dave Peterson