the only way is to open the workbook without running the macros.
if you put this code into a new workbooks module and run it. it will allow you to open the file withough running the workbook open event.
Sub openxlfile_MacroOff()
Dim var_File As Variant
'select workbook to open
var_File = Application.GetOpenFilename _
("All Files(*.*),*.*", Title:="Please select the Files you wish to open as macro disabled.")
'disable the macro open events for file
Application.EnableEvents = False
'open file
Workbooks.Open (var_File)
Application.EnableEvents = True
End Sub
hope this helps
Bookmarks