Perhaps the sheet is already protected when this line is run.
"Mick" wrote in message
...
Can any advise how I can overcome this Run-time error when using the code
below:

Unprotect method of worksheet class failed

Worksheets("Template").Protect Password:="MyPassword"

--
Kind Regards

Mick