Hi,

How to lock a particular cell without locking the whole work sheet

Pls help me.

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?

By default all cells on a sheet are locked when the sheet is
protected.

Select all cells(CTRL + a...........twice in Excel 2003) then go to
formatcellsprotection and unlock all.

Now select just the cells you want locked and mark them as locked.

Protect the sheet.


Gord

On Tue, 13 Mar 2012 19:26:54 +0000, Moideen
wrote:


Hi,

How to lock a particular cell without locking the whole work sheet

Pls help me.

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

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.

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