Well, I opened your zip file, got a message box saying "Hi" and there was no code modules, so it must have worked (Office 2k) And if I had saved there would be a workbook minus a module saved.

In Excel 2002 or above the "Trust Access To Visual Basic Project" box must be selected in Tools|Options|Security|Macro Security or the macro won't run, has this been done?

If you also want to delete all code referring to this from the Workbook_Open event I suggest you have a read of this article to see how to go about it