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

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

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

--

Dave Peterson

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

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

Thank you Dave! Just what I needed!!! Deleting the module 1 and module 2
files did the trick. We have put up with this annoying function for 2 years.
Bossman will be happy!
--
gevans


"Dave Peterson" wrote:

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

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

--

Dave Peterson