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

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