Sorry the code line should read .Unprotect not .Protect

Mick

"Mike Fogleman" wrote in message
news:9Mtbd.390133$Fg5.7832@attbi_s53...
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