how do I lock formulas, but still allow rows to be added or delet.
 

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?

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?

how do I lock formulas, but still allow rows to be added or delet.
 

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?

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