Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking non-Validation cells in ranges
Having trouble getting the following to do.
Any advice would be good. Sandy Dim rngPossibleValidation As Range Dim rngValidation As Range Set rngPossibleValidation = Range ("O4,05,C14:K14,M14:U14,C15:K15,M15:U15,C21:K21,M2 1:U21, C23:K23,M23:U23,C27:K27,M27:U27,C33:K35,M33:U35,C3 9:K41, M39:U41,C53:K53,M53:U53,C56:K56,M56:U56,C59:K59,M5 9:U59") rngPossibleValidation.Cells.Locked = True Set rngValidation = Cells.SpecialCells(xlCellTypeAllValidation) rngValidation.Cells.Locked = False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Dynamic Ranges | Excel Discussion (Misc queries) | |||
How do I use Named Ranges as Data Validation Lists? | Excel Worksheet Functions | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Data validation using multiple ranges | Excel Discussion (Misc queries) | |||
Validation protection with named ranges | Excel Worksheet Functions |