Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock cell
Mohamed,
Here's a starting point in VBA. Sub LockCell() Dim rngCell As Range With Sheets(1) Set rngCell = .Range("a1") .Unprotect .Cells.Locked = False rngCell.Locked = True .Protect contents:=True End With End Sub Robin Hammond www.enhanceddatasystems.com "Mohamed" wrote in message ... How to lock a cell which contains a formula |
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 |