Ghost macro

[Byron Poston]

My spreadsheet has no macros but everytime it is opened, up pops the dialog
that says "Unable macros or Disable macros". How can I keep the dialog from
coming up each time the sheet is opened? Thanks, Barney

 

[David McRitchie]

Hi Barney,
Did you remove the modules that the macros were in, and
remove the code associated with sheets and ThisWorkBook.
You can read more about this and use a macro to remove them.
Coding for the Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm

 

[Debra Dalgleish]

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 some instructions here for finding and removing the
module, or any remaining code:

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

 

[Barney]

Thanks, that worked. Barney

Hi Barney,
Did you remove the modules that the macros were in, and
remove the code associated with sheets and ThisWorkBook.
You can read more about this and use a macro to remove them.
Coding for the Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

My spreadsheet has no macros but everytime it is opened, up pops the dialog
that says "Unable macros or Disable macros". How can I keep the dialog from
coming up each time the sheet is opened? Thanks, Barney

 

[Barney]

Thanks, Debra. That worked too. Barney

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 some instructions here for finding and removing the
module, or any remaining code:

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