Finding all cells that are locked/hidden

B

Bob

Similar to Excel's "Go To Special" feature (Edit | Go To... | Special), I
need a quick and easy way to find and highlight all cells whose protection
has been set to locked and/or hidden.

Is there a way I can do that in Excel, or is there a third-party add-in that
can help?

Thanks,
Bob
 
R

RebootRon

Bob said:
Similar to Excel's "Go To Special" feature (Edit | Go To... | Special), I
need a quick and easy way to find and highlight all cells whose protection
has been set to locked and/or hidden.

Is there a way I can do that in Excel, or is there a third-party add-in that
can help?

Thanks,
Bob
 
Top