RunTime Error 57121

G

Guest

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
 
G

Guest

Is the sheet possibly hidden? You can not select a hidden sheet.
try this...

with Sheets("TransferHeader")
.Visible = xlSheetVisible
.Select
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 57121 5
Error Number 57121 5
###Error 57121### 2
worksheets.select doesn't work 4
treeview and laptops 3
Run-Time error 57121 0
resetting controlsource cells 1
Runtime error 1004 when trying to insert formula in cells 11

Top