When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions here for finding and removing code:


http://www.contextures.com/xlfaqMac.html#NoMacros


Ralph Orth wrote:
Every time I open workbooks that were created when I had macros in the
personal sheet, Excel states there are macros in the sheet, even though none
show up. (I deleted macros that were not needed in some spreadsheets.) It is
not a big deal, but rather just an annoyance, and the sheets are good to
use. I have copied the contents of many to another new workbook already, and
that gets rid of it, but where would Excel be getting this info if all the
macros are deleted?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html