View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ted M H Ted M H is offline
external usenet poster
 
Posts: 83
Default How to select all unlocked cells on a sheet?

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?