| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
| Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
| Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
| Run-time error '11' & Run-time error '1004' | Excel Programming | |||
![Mick[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
