Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to lock cell
Hi,
How to lock a particular cell without locking the whole work sheet Pls help me. |
#2
|
|||
|
|||
Quote:
Or do you mean have a locked cell but without protecting the work sheet? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
|
|||
|
|||
Yes, I mean have a locked cell but without protecting the work sheet.
|
#5
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions |