Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to select all locked cells on a worksheet.
How can I find all of the locked cells without having to loop through every individual cell on the worksheet? I know range.locked will return true if all cells in the range are locked but it will return false if one or more of the cells are unlocked. This makes it impossible to eliminate large areas of the workbook which may have unlocked cells without checking each individual cell. Thanks for any help Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Delete specific cells contents in a row with some locked cells in the same row | Excel Programming | |||
I want the macros to be locked up when cells are locked up. | Excel Programming |