F
Fred
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
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