Macro warning with no macros...

DanExcel · May 5th, 2002, 02:19 PM

Hello,

I have a worksheet where I had macros at one time, but subsequently deleted them. With this worksheet, I still get a warning about macros whenever I open the sheet. Has anyone else had this problem? It's not a huge problem, but it is an annoyance, particularly when I distribute the sheet to others...

Thanks,

DanExcel

sen_edp · May 5th, 2002, 02:25 PM

Did you remove the module that contained the macros? The presence of an
empty module will trigger the macro warning. To remove a module, make sure
the Project explorer window is open in the VB editor (View|Project
Explorer), right click the module and choose "Remove Module".

Nimrod · May 5th, 2002, 02:25 PM

Why not just copy the sheets to a new workbook, delete old workbook , rename new one ?

DanExcel · May 5th, 2002, 02:30 PM

sen_edp,

Removing the module took care of it. Thank you.
Thanks to Nimrod too for the suggestion.

-DanExcel

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

May 5th, 2002, 02:19 PM	#1
DanExcel New Member Join Date: Mar 2002 Posts: 29	Hello, I have a worksheet where I had macros at one time, but subsequently deleted them. With this worksheet, I still get a warning about macros whenever I open the sheet. Has anyone else had this problem? It's not a huge problem, but it is an annoyance, particularly when I distribute the sheet to others... Thanks, DanExcel

May 5th, 2002, 02:25 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Did you remove the module that contained the macros? The presence of an empty module will trigger the macro warning. To remove a module, make sure the Project explorer window is open in the VB editor (View\|Project Explorer), right click the module and choose "Remove Module".

May 5th, 2002, 02:25 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Why not just copy the sheets to a new workbook, delete old workbook , rename new one ?

May 5th, 2002, 02:30 PM	#4
DanExcel New Member Join Date: Mar 2002 Posts: 29	sen_edp, Removing the module took care of it. Thank you. Thanks to Nimrod too for the suggestion. -DanExcel