PROTECT Formula in Column

KATHWUN · Apr 12th, 2002, 11:22 AM

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 · Apr 12th, 2002, 11:31 AM

Quote:

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 · Apr 12th, 2002, 11:39 AM

Accomplished! Thank you, Brian.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 11:22 AM	#1
KATHWUN Board Regular Join Date: Apr 2002 Location: California Posts: 61	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?

Apr 12th, 2002, 11:39 AM	#3
KATHWUN Board Regular Join Date: Apr 2002 Location: California Posts: 61	Accomplished! Thank you, Brian.