I jumped straight from Excel 2003 to 2010, and I've never used an auto-run macro. But it seems to me you just have tochange Excel's security settings so they won't try to run the auto-open macro, and then open the workbook. At that point, I expect Excel will warn you that there are macros in the workbook, and ask you whether to enable them. Leave them disabled, then go to the VBA editor and change the macro so it won't run automatically.

If you created the macro yourself, then at this point you can go back to running the macro manually, debugging until you figure out why it's not working properly. If you didn't create it, then of course you first want to make sure you want to run it at all. What if it's a virus?

...med vänliga hälsningar / Bob