how to remove the popup that reads, "the workbook you are opening contains macros" upon opening an e

[darren.yada]

Im creating a workbook, and was thinking of using a macro. I've decided
otherwise, and can not get rid of the prompt that reads:

"the workbook you are opening contains macros" with the options to
"enable macros","do not open" or "disable macros.

This message pops up as soon as I open the document, and is causing
frustration amoung other users of this document. I've since "enabled
macros" and then deleted all macros I created, but I am still prompted
with the above message.

Does anyone know how to remove this message?

Any help is much appreciated!!

 

[Trevor Shuttleworth]

In the VB Editor, right click on the Module(s) and select "Remove
Modulex..." where x is a number. Choose "No" in the dialogue box.

Regards

Trevor

 

[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 instructions here for finding and removing code:

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

 

[darren.yada]

awesome it worked!
thanks so much

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 instructions here for finding and removing code:

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

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.

awesome it worked!
thanks so much