Help protecting spreadsheet with password from code

[lanem]

I'm trying to protect spreadsheet from code. I can get it to protect, but I
can't get it to protect with a password. Here's my code:

Dim xl As New Spreadsheet
xl.ActiveSheet.Protect("testpassword")

Thanks for your help.

 

[Chip Pearson]

Do you get any error message. Your code should work as written.

 

[lanem]

This is the error I get:

System.Runtime.InteropServices.COMException: Exception from HRESULT:
0xE0040059

 

[Karl E. Peterson]

This is the error I get:

System.Runtime.InteropServices.COMException: Exception from HRESULT:
0xE0040059

That's definitely not VBA...