Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 57121
To unprotect my entire workbook on opening, I start on ThisWorkbook the
following procedure : Private Sub WorkBook_Open() Application.ScreenUpdating = False For Each WkSht in Worksheets WkSht.Unprotect Password:="mypassword" Next WkSht I have a lot of workbooks with this procedure fuctioning properly, however there is one which each time results in Runtime error 57121 : Applikcation-defined or object-defined error. Debugging points me to the line : WkSht.Unprotect Password:="mypassword" (In the same workbook I have a macro, using the same code, wich is working without errors.) Any idea how to solve this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime error 57121 | Excel Discussion (Misc queries) | |||
RunTime Error 57121 | Excel Programming | |||
Run-Time error 57121 | Excel Programming | |||
###Error 57121### | Excel Programming | |||
error 57121 | Excel Programming |