Hi,

Anyone have any ideas why the following code does not work (Invalid procedure call or argument):

ThisWorkbook.Protect structure:=True, Windows:=False, Password:=ThisWorkbook.Worksheets("Workings").Range("nrProtectionPW")
*nrProtectionPW" is a named range storing the password of XXXX

Yet SHEET protection works:

Worksheets("Payment Timeline").Protect Password:=ThisWorkbook.Worksheets("Workings").Range("nrProtectionPW")
And a hard coded password works:

ThisWorkbook.Protect structure:=True, Windows:=False, Password:="XXXX"
I'm sure I'm missing something here but I can't figure out what. Any help appreciated.

TC