Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a sub procedure that selects all unlocked cells on a worsheet.
Go to special doesn't offer this as an option. What I want to do is akin to something like Selection.SpecialCells(xlCellTypeBlanks).Select, but instead of blanks I want to select cells where Locked = False. I've tried a few things with Application.FindFormat.Locked = False, but I can't figure out to select ALL the FindFormat.Locked = False cells. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select locked/unlocked cells | Excel Programming | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
How select unlocked cells only | Excel Programming | |||
Password Protection - Select Unlocked Cells Only | Excel Programming | |||
Select all the unlocked cells on a worksheet | Excel Programming |