Yes, I mean have a locked cell but without protecting the work sheet.

I think it's only possible with VBA.
Have a look at this link for further advice as it's nothing I've ever needed to do before so cannot really advise myself.

http://www.mrexcel.com/forum/showthread.php?t=44323

I have been using the below mentioned VBA code for cell protection,
It is protected only "A2" We need to protect from A2 to A8, Pls help me.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.Address < "$A$2" Then Exit Sub

Application.EnableEvents = False

MsgBox "Hey, leave me alone!"

Application.Undo

Application.EnableEvents = True

End Sub

Cannot be done.

Sheet must be protected in order to lock cells.


Gord


On Wed, 14 Mar 2012 07:51:14 +0000, Moideen
wrote:


Spencer101;1599757 Wrote:
Do you mean have one particular cell that cannot be updated/altered but
the rest can?

Or do you mean have a locked cell but without protecting the work sheet?

Yes, I mean have a locked cell but without protecting the work sheet.