Disable a cell in excel
 

Is it possible in excel to disable a particular cell?

Thx in adavance.
SK

Disable a cell in excel
 

Now I kinda figured it out. But the problem is when
selecting the disabled cell and drag outside to extend
the series, the protection is only applied to the original
one. Is there any workaround?

Sub prt()
With ActiveSheet
.Cells.Locked = False
With Range("B4")
.Value = "MyValue"
.Interior.ColorIndex = 15
.Locked = True
End With
.Protect Password:="mypassword"
End With
End Sub


SK

Disable a cell in excel
 

Disable could have several interpretations, but if you meant for entry:
set its locked property to true and protect the sheet.

Certainly not foolproof.

--
Regards,
Tom Ogilvy


"Shinya Koizumi" wrote in message
...
Is it possible in excel to disable a particular cell?

Thx in adavance.
SK

Disable a cell in excel
 

Hi Shinya,

Had a somewhat similar problem to yours, for which I placed all the
"disabled" cells in a dedicated hidden sheet ...
HTH
Cheers
Carim