| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN WE LOCK CELLS AT F COLUMN BASED ON VALUE AT C COLUMN
HI ALL,
' at start all cells in range c5:c1000 will be 0 ' wish to lock cell f5:f1000, when c5:c1000 is 1 ' wish if f5:f1000 access itself is not possible when c5:c1000 is 1 Private Sub Worksheet_Change(ByVal Target As Range) Set Target = Range("c5:c1000") If Target.cell(0, 3) = 1 Then Target.Cells.Offset(0, 3).Locked = True Else Target.Cells.Offset(0, 3).Locked = False End If End Sub PL HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells in one column based on value in another column | New Users to Excel | |||
| Total cells of one column based on the values in another column? | New Users to Excel | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
Threaded Mode
