Lock one single cell on a worksheet using Excel 2003.
 

I have tried to follow the instructions for locking a single cell, however, I
am unsuccessful. The instructions are from the Microsoft Online help. If
someone has been successful with this task please let me know. I am anxious
to figure this out.
--
Appreciate any tips. Thanks!

Lock one single cell on a worksheet using Excel 2003.
 

1. Unlock all cells
2. Lock the selected cell
3. Protect the worksheet
--
Gary''s Student - gsnu200758


"Sally" wrote:

I have tried to follow the instructions for locking a single cell, however, I
am unsuccessful. The instructions are from the Microsoft Online help. If
someone has been successful with this task please let me know. I am anxious
to figure this out.
--
Appreciate any tips. Thanks!

Lock one single cell on a worksheet using Excel 2003.
 

Without protect of sheet:

Data/Validate/Personnal

=Len(A1)=0

JB
http://boisgontierjacques.free.fr/

On 24 nov, 04:07, Sally wrote:
I have tried to follow the instructions for locking a single cell, however, I
am unsuccessful. The instructions are from the Microsoft Online help. If
someone has been successful with this task please let me know. I am anxious
to figure this out.
--
Appreciate any tips. Thanks!