| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RunTime Error 57121
When running a macro that is called from the workbook open area. The called
macro is in module 1, sometimes users get this error: runtime error 57121, Application-defined or object-defined error. Any ideas why I get this. I can't get rid of the error except to end execution. The line stuck on is: Sheets("TransferHeader").Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RunTime Error 57121
Is the sheet possibly hidden? You can not select a hidden sheet.
try this... with Sheets("TransferHeader") .Visible = xlSheetVisible .Select End With -- HTH... Jim Thomlinson "Mike H." wrote: When running a macro that is called from the workbook open area. The called macro is in module 1, sometimes users get this error: runtime error 57121, Application-defined or object-defined error. Any ideas why I get this. I can't get rid of the error except to end execution. The line stuck on is: Sheets("TransferHeader").Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime error 57121 | Excel Discussion (Misc queries) | |||
| 57121 error, but not a Mac in sight | Excel Programming | |||
| Run-Time error 57121 | Excel Programming | |||
| ###Error 57121### | Excel Programming | |||
| error 57121 | Excel Programming | |||
Linear Mode
