I opened VBE. I'm not sure I know where to look for "events" or "modules", I
am not familiar with the VBE function.
It is possible that a macro opens with Excel, but this is the only
spreadsheet that gives me the warning, so I'm thinking the problem is limited
to this spreadsheet.
--
gevans


"DaveO" wrote:

> 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