Hit Alt+F11 and this will open the VBE.

Now all you need to do it go through all of the worksheets and the
'ThisWorkbook' you have to see if there are any events.

If not check to see if there are any modules in the sheet.

If not, my only advise would be to see if you have a macro in the sheet
which you are opening when you simply open excel.

HTH.

"gevans" wrote:

I have a very large spreadsheet that gets copied every month as a new
template. Somewhere along the line it has aquired a "ghost" macro. It
causes the "macro alert" warning to come up everytime the spreadsheet is
opened. Under the menu item for macros, there are none listed for this
spreadsheet. There are no links to outside sheets. How do I find and delete
the ghost macros?
--
gevans