Unanswered: Unable to stop "On Open" macro from running
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.
Liv'n down on the cube farm. Left, then another left, then right.