macro deletion help

croweld89 · Apr 23rd, 2002, 07:56 AM

I had a print macro attached to a file i roll-over for each month. I didn't like the macro and therefore deleted it. The problem is that Excel still asks if I want to open the file with macros enabled or disabled.

Is there any way to completely remove the footprint of a macro in an excel file? Thanks for your help.

-Dave

Anne Troy · Apr 23rd, 2002, 08:19 AM

Hit Alt-F11 to get to the VB Editor window. Likely, you deleted the code, but the empty module is still there. Right-click and remove it. Do not export it (you won't want to).

croweld89 · Apr 23rd, 2002, 08:21 AM

Thanks,

I had removed the module and that stopped the macro message, but I wanted to make sure that all traces of the macro were removed. Thanks again for your help.

Apr 23rd, 2002, 08:19 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Hit Alt-F11 to get to the VB Editor window. Likely, you deleted the code, but the empty module is still there. Right-click and remove it. Do not export it (you won't want to). __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 07:56 AM	#1
croweld89 New Member Join Date: Mar 2002 Posts: 34	I had a print macro attached to a file i roll-over for each month. I didn't like the macro and therefore deleted it. The problem is that Excel still asks if I want to open the file with macros enabled or disabled. Is there any way to completely remove the footprint of a macro in an excel file? Thanks for your help. -Dave

Apr 23rd, 2002, 08:21 AM	#3
croweld89 New Member Join Date: Mar 2002 Posts: 34	Thanks, I had removed the module and that stopped the macro message, but I wanted to make sure that all traces of the macro were removed. Thanks again for your help.