ExcelBanter - Help with run-time error, please...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help with run-time error, please... (https://www.excelbanter.com/excel-programming/313508-help-run-time-error-please.html)

Mick[_3_]

Help with run-time error, please...

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

Mike Fogleman

Help with run-time error, please...

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

Mick[_3_]

Help with run-time error, please...

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

All times are GMT +1. The time now is 04:33 PM.