| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to lock columns b thru d based on value selected in col a
This code needs to apply to one row at a time.
Column A - each cell has data validation -- possible values of Yes and No. If the user chooses 'Yes' in A1, I need to unlock B1 thru D1 (and keep them that way), otherwise those cells should be locked. Same thing on row 2, etc, down to possible 300 rows or more. -- thanks for your assistance, cm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lock the selected cells in 2007 | Excel Discussion (Misc queries) | |||
| Scroll Lock for selected multiple sheets | Excel Worksheet Functions | |||
| Write macro to lock selected sheet when run | Excel Discussion (Misc queries) | |||
| How to Lock the selected cells in Excel worksheet | New Users to Excel | |||
| How do I lock selected cells, so only I can change them? | Excel Worksheet Functions | |||
Threaded Mode
