Viewing Formulas in Locked Cells

  • Thread starter Thread starter stacy05
  • Start date Start date
S

stacy05

Hello-
I am trying to figure out how I can set a preference on the locked cells. I
want the 'user' to be able to look at the formula in the cell when you click
on it, but NOT to be able to make any changes on it. I didn't see this as an
option when I was locking the cells. Any ideas?

Thanks in advance!
Stacy
 
Unprotect worksheet/workbook
Mark cell with formula as locked, but not hidden
Protect worksheeet, allowing users to select both locked and unlocked cells
 
Back
Top