Hi everyone

I am using these two lines of code to determine whether or not workbook
protection or worksheet protection has been turned on.

If ActiveWorkbook.ProtectStructure = True Then ...
If ActiveSheet.ProtectContents = True Then ...

this works fine,but I would like to know of it is possible to detect if
either of these methods of protection, if being used, are password
protected. I am a bit stumped here.

Thanks for any advice.

DJB


--
DJB
------------------------------------------------------------------------
DJB's Profile: http://www.excelforum.com/member.php...o&userid=21221
View this thread: http://www.excelforum.com/showthread...hreadid=375003