HasPassword Property

         Example         Applies To

True if the workbook has a protection password. Read-only Boolean.

Remarks

You can assign a protection password to a workbook by using the SaveAs method.