PROTECT Formula in Column

[KATHWUN]

How to use standard protect-formula for column while keeping formula active in column. Don't want anyone attempting to input data in these cells. I've used "Comment" saying "NO Data Entry Required: formula will determine", but want a backup protection. Can this be done without a password?

 

[Brian from Maui]

On 2002-04-12 10:22, KATHWUN wrote:
How to use standard protect-formula for column while keeping formula active in column. Don't want anyone attempting to input data in these cells. I've used "Comment" saying "NO Data Entry Required: formula will determine", but want a backup protection. Can this be done without a password?

Go to Format/Cells/Protection click locked and hidden. Then to Tools/Protect/Protect Worksheet. Enter without password

 

[KATHWUN]

Accomplished! Thank you, Brian.