Locked cells
 

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

Locked cells
 

Hi Fred,

I think that the only way you can do this is to loop through the cells.
There is code at the following site to select the unlocked cells. Just change
the following line to = true.

If Cell.Locked = False Then


http://www.j-walk.com/ss/excel/tips/tip99.htm

--
Regards,

OssieMac


"Fred" wrote:

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


.