Locked cells


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top