Ok Tom, thanks..........


"Tom Ogilvy" wrote in message
...
Only by running code - so if your going to run code anyway, it might be
just
as easy to run a routine to do the checking (and correcting).

--
Regards,
Tom Ogilvy

"CLR" wrote in message
...
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