Protect Formulas
 

Is there a way to protect formulas from being deleted when clearing cell
from current data?


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=526260

Protect Formulas
 

parteegolfer, one way select the range you want to clear, then edit goto
special, select constants, Ok, delete

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"parteegolfer"
wrote in message
news:parteegolfer.257d9y_1143252001.6402@excelforu m-nospam.com...

Is there a way to protect formulas from being deleted when clearing cell
from current data?


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=526260