How to select all locked cells in an worksheet?

[vk7]

I wanted to select all locked cells in an worksheet? I have googled it but there are several steps mentioned, one is using Find method (which doesn't work for me) and others are using some formula (which again doesn't work for me).

Could someone tell me, what is the easiest way to select all locked cells in an worksheet?

 

[NARAYANK991]

Hi ,

If two proven methods do not work for you , it would be informative to know why they do not work , rather than try and look for a third method , which for all we know , may also not work.

Narayan

 

[Deepak]

There might chance that your worksheet is protected.