Excel 2007

I can not get an "On Open" macro to stop firing. I try holding the shift when I open the file, but then it just opens all the files in the folder, and the macro fires. I try opening Excel itself while holding the shift, but when I open the file the macro still fires. Any ideas? I need to edit the file but when the macro fires it populates a sheet, and I do not want to save the file with the sheet populated, nor can I just depopulate the sheet.