Sopunds like you are opening this workbook from within another workbooks vba code. So not too much you can do. If its in your primary workbook you can do this.
VB Code:
  1. Private Sub Workbook_Open()
  2.     'Bypass
  3.     Exit Sub
  4.     'Other open code
  5.     'Blah, blah, blah
  6. End Sub