Worksheet nearly perfect, now how can I protect the formulas where i
might be able to still change a value in a formula but the formulas can
not be changed.

Or whatever you think is the best way to protect a worksheet?

Thanks in advance


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=505425

Do you mean that you want to protect certain cells? do you have data in one
cell that is acted upon by another cell?

if so, then unlock the cells that you enter data in and protect the
worksheet.



"darkbearpooh1"
wrote in message
news:darkbearpooh1.2297zf_1138299704.6387@excelfor um-nospam.com...

Worksheet nearly perfect, now how can I protect the formulas where i
might be able to still change a value in a formula but the formulas can
not be changed.

Or whatever you think is the best way to protect a worksheet?

Thanks in advance


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=505425

More specifically, highlight the cell or cells you want to be able to
access after you protect the worksheet. Then go to FORMAT - CELLS -
PROTECTION and then uncheck LOCKED. Then protect your worksheet.


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=505425