Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros

Ron wrote:

One of my Excel data files opens with the Macro Security Warning. I don't
know of a Macro in this file. If I go to the Tools menu and open Macros, it
does not show any macros. How do I delete this? Is there a macro hidden
that I can't see?

--

Dave Peterson