Macro HELP

danam531 · May 20th, 2002, 10:27 AM

I have an Excel file in which there are NO macros. However, when I open the file, the macro message comes up asking to disable or enable macros. Originally, there were macros in the file but I deleted them all - Excel is just not recognizing it. Can anyone help?

NateO · May 20th, 2002, 10:41 AM

In the Visual Basic Editor's (alt+f11) project explorer (ctrl-r), check all modules in the workbook, normal modules, sheet modules (e.g, sheet1) and user form modules.

I've heard that not deleting normal modules that once held code, even after deleting the code, will trip the prompt. Right-click on the module and select remove, no need to export.

Hope this helps.
_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-20 09:49 ]

danam531 · May 20th, 2002, 01:49 PM

Thank you, that worked.

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

May 20th, 2002, 10:27 AM	#1
danam531 New Member Join Date: May 2002 Posts: 40	I have an Excel file in which there are NO macros. However, when I open the file, the macro message comes up asking to disable or enable macros. Originally, there were macros in the file but I deleted them all - Excel is just not recognizing it. Can anyone help?

May 20th, 2002, 10:41 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	In the Visual Basic Editor's (alt+f11) project explorer (ctrl-r), check all modules in the workbook, normal modules, sheet modules (e.g, sheet1) and user form modules. I've heard that not deleting normal modules that once held code, even after deleting the code, will trip the prompt. Right-click on the module and select remove, no need to export. Hope this helps. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-20 09:49 ]

May 20th, 2002, 01:49 PM	#3
danam531 New Member Join Date: May 2002 Posts: 40	Thank you, that worked.