Protecting a Cell

  • Thread starter Thread starter Mark1
  • Start date Start date
M

Mark1

Is there a way to protect a cell's formula without
protecting the worksheet. I want people to be able to key
in data, but not change my formulas.
 
Hi Mark
1. Highlight all cells for which people are allowed to perform entries
2. Goto 'Format - Cells - Protection" and uncheck/disable the
protection for these cells
3. Protect the worksheet

HTH
Frank
 
Back
Top