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
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
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]...
>
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks