Go into the VBE (alt+F11), look at the project explore (Ctrl+R), if you have
an entry Modules under your workbook, then expand that and right click on
each module and select Remove. You can decline to prompt to export it.

double click on each entry for sheet
click in the resulting module, do Ctrl + a, then delete key, click the X in
the upper right corner of the module.

do this for the ThisWorkbook entry as well.

Now go back to excel and save the workbook.

--
Regards,
Tom Ogilvy


"mcm" wrote in message
...
I'm currently working on a worksheet which was suppose to not have
macros in it. When I checked whatever macros there were in that
worksheet I noticed that there was one. I tried to delete it but the
'Delete' button is not activated. When I tried to run the macro, excel
returned an error message telling me that the link to this macro cannot
be found or somethin' like that. How can i clean up that macro list in
excel?