determine if Worksheet protected

[Brian.Crawford]

Excel 2007. In my VBA code I protect and unprotect some WS as needed but in some cases (where I am processing all WS in a loop) I need to determine if it is currently unprotected so I can leave it in that state rather than protect it by default at the end it its processing. Basically I want to set them back to their previous state regardless of waht I need to do with them.

How can I test to see if it is already protected or not.

Thanks
Brian

 

[VoG]

Maybe like this

If ActiveSheet.ProtectContents Then

 

[Brian.Crawford]

Great, thanks a lot
Brian