Lock out cells

Q45 · Apr 5th, 2002, 08:15 AM

How do I lock out cells where I have put formulas so that someone else can't type over that cell? Thanks.

Brian from Maui · Apr 5th, 2002, 08:31 AM

Go to Format/Cells, click on Protection. Then go to Tools/Protection/protect worksheet

[ This Message was edited by: Brian from Maui on 2002-04-05 07:48 ]

nancyo · Apr 5th, 2002, 08:31 AM

On the specific cell, right click. Select format, protection, and check off locked. In order for this to work, the worksheet must be protected (tools, protection, protect sheet, password, re-enter password).

Q45 · Apr 5th, 2002, 08:38 AM

I have done both of these things. It doesn't work. Am I missing something?

Brian from Maui · Apr 5th, 2002, 08:49 AM

On the Protection tab, click lock and hidden, then protect the worksheet

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

Apr 5th, 2002, 08:15 AM	#1
Q45 New Member Join Date: Feb 2002 Posts: 32	How do I lock out cells where I have put formulas so that someone else can't type over that cell? Thanks.

Apr 5th, 2002, 08:31 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Go to Format/Cells, click on Protection. Then go to Tools/Protection/protect worksheet [ This Message was edited by: Brian from Maui on 2002-04-05 07:48 ]

Apr 5th, 2002, 08:31 AM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	On the specific cell, right click. Select format, protection, and check off locked. In order for this to work, the worksheet must be protected (tools, protection, protect sheet, password, re-enter password).

Apr 5th, 2002, 08:38 AM	#4
Q45 New Member Join Date: Feb 2002 Posts: 32	I have done both of these things. It doesn't work. Am I missing something?

Apr 5th, 2002, 08:49 AM	#5
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	On the Protection tab, click lock and hidden, then protect the worksheet