worksheet protection

D

darkbearpooh1

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
 
J

jiwolf

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" <[email protected]>
wrote in message
news:[email protected]...
 
P

pdgaustintexas

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.
 
Top