Locked cells
in [Programming]
|
From: Fred on 1 Feb 2010 18:49 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
From: OssieMac on 1 Feb 2010 20:17 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 > > > . >
|
Pages: 1 Prev: Hide Message Bar Next: How do I find the currently selected Scenario? |