View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 149
Default highlight locked cells

I just inherited a very large legacy spreadsheet that has a good bit of
locked cells throughout. Is there a way to maybe iterate through a page and
highlight or other formating of just cells that are locked?

It's very time-consuming to manually check a lot of cells to see if they
have been locked.