get rid of macro option at startup

[Brad Rench]

I created and then deleted a macro in an Excel file.

Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?

Is there a way to get rid of this since I no longer have macros in this
file?


Thanks.

Brad

 

[Bill Kuunders]

You need to delete the empty module.!
Bill K

 

[Debra Dalgleish]

When you create a macro, Excel saves it in a module. As long as the
module is in the workbook, you'll get the macro warning. There are some
instructions here for removing it:

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

 

[Brad Rench]

Thanks, Debra!

When you create a macro, Excel saves it in a module. As long as the
module is in the workbook, you'll get the macro warning. There are some
instructions here for removing it:

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