View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR[_2_] CLR[_2_] is offline
external usenet poster
 
Posts: 28
Default Sheet Protection Identifier

Hi All.......

I regularly work on WorkBooks that require some of the sheets to be
Protected, and some not. Naturally while I'm editing them, I must turn the
Protection off. Once I get ready to save the WorkBook, I have to check each
sheet individually to see if it's protected or not..
Is it possible to somehow indicate on a Sheet Tab, whether or not that
sheet is Protected?. Maybe change tab color, or add an * to the Sheetname,
or something?

Any help would be appreciated.....

Vaya con Dios,
Chuck, CABGx3