How to lock cell
Hi,
How to lock a particular cell without locking the whole work sheet Pls help me. |
Quote:
Or do you mean have a locked cell but without protecting the work sheet? |
How to lock cell
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. |
Quote:
|
Quote:
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 |
How to lock cell
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. |
Quote:
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 |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com