View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Finding all cells that are locked/hidden

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