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