I am trying to protect a formula in a cell. I want others to be able to
change data in other cells on the worksheet but don't want them to change any
cells that I have a formula in.
I have followed the direction of all the replies on this type of post but I
am still unable to make this work.
When you say 'select a sheet' does the entire sheet have to be highlighted
or something? Also, after you have locked/unlocked the applicable cells you
then have to protect the sheet.
When you protect the sheet what should/should not be checked.
Can anyone help???