Test if protected

[Steven]

How do you tell if the active file workbook protect is activated? For Sheet
protect test I have used:

If ActiveSheet.ProtectContents = True Then ............

For the Workbook I tried:

If ActiveWorkbook.ProtectContents = True Then ..........

But that does not work.

Thanks for your help,

Steven

[Chip Pearson]

Steven,

If ActiveWorkbook.ProtectStructure Or
ActiveWorkbook.ProtectWindows Then
Debug.Print "workbook is protected"
Else
Debug.Print "workbook not protected"
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steven" <[email protected]> wrote in message
news:[email protected]...
> How do you tell if the active file workbook protect is
> activated? For Sheet
> protect test I have used:
>
> If ActiveSheet.ProtectContents = True Then ............
>
> For the Workbook I tried:
>
> If ActiveWorkbook.ProtectContents = True Then ..........
>
> But that does not work.
>
> Thanks for your help,
>
> Steven