Hi Tim,
Thanks for participating in the community!
From my understanding to this issue, you are going to obtain one range
object which points to these locked cells in your workbook.
So far as I know, the method from Brad is the solution in this scenario.
From Excel object, there is no one method for us to pick up these locked
cells directly.
If you have any further question regarding this, please feel free to let me
know. Enjoy a nice weekend!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.