Protecting a Cell

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

Frank Kabel

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
 
Top