Can't Remove a Macro from Excel Workbook

  • Thread starter Thread starter Dean deancarpenter
  • Start date Start date
D

Dean deancarpenter

A while back, I created a simple macro in an excel
workbook that I regularly used. After a few days of use,
I realized that it was a stupid macro, and deleted it from
the workbook.

Since then, every time I open the workbook, a pop up
window asks me if I want to enable or disable macros in
the workbook. There are no macros so why is it asking me
this question?

Any help I can get in removing this is appreciated.
 
Dean,

You need to remove the module in which the macro was stored. Even
an empty module will cause the warning message to be displayed.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dean (e-mail address removed)"
 
Being a dummy in Excel, do you mean remove the worksheet
that the Macro was stored in, or something else. If it's
something else, can you tell me how to do it??

Thanks in advance again for all your help!
 
Dean,

open the workbook in questions, press alt + F11, find the workbook (the name
of the workbook) in the left project pane,
right click the Module(s) (looks like a folder), select remove module,
select no when prompted to export it.
Close the VBA editor with alt + Q. Save the workbook..
 
Worked great! Thanks for all the help!

-----Original Message-----
Dean,

open the workbook in questions, press alt + F11, find the workbook (the name
of the workbook) in the left project pane,
right click the Module(s) (looks like a folder), select remove module,
select no when prompted to export it.
Close the VBA editor with alt + Q. Save the workbook..

--

Regards,

Peo Sjoblom


"Dean (e-mail address removed)"
Click to expand...
 
Back
Top