removing macros

scottie T

New Member
Joined
Nov 18, 2005
Messages
8
Hi, with this post I am losing my mrexcel message board virginity. I hope it was worth the wait.

I was working a file and recorded a macro, which I have deleted. Well, I think I have deleted it.

Whenever I open the file, the Disable/Enable Macros pop up pops up, which I would like to get rid of. How do I get rid of that?

TIA
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
670
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Hi ScottieT , Welcome To The Board.

Search this forum for :

"Removing all macro traces "

Points you in a direction that will solve your
issue.

Hope this helps the "First Timer !!!!!! "

Russ.
 

KenCriss

Active Member
Joined
Jun 6, 2005
Messages
323
There is probably some code in ThisWorkbook that you don't readily see. Use the Visual Basic Editor (VBE) to look for code and then delete it.
 

pcc

Well-known Member
Joined
Jan 21, 2003
Messages
1,345
In the VB editor, you need to remove the module that the macro was in as well as deleting the macro itself
 

scottie T

New Member
Joined
Nov 18, 2005
Messages
8

ADVERTISEMENT

Okay, I went to VB, then view, then code, selected worksheet from the pull down menu, see the code there & have deleted it & then saved the file. I close the file, then open it, still get the disable/enable pop up, and the code is still there!!

:unsure:
 

scottie T

New Member
Joined
Nov 18, 2005
Messages
8
So I did the search suggested by Russ and found this:

"You also need to delete the modules which housed the macros. In the VB editor, go to the Project Explorer, look at all the modules under your file, right click on each module and select "Remove ModuleX".

Once you get rid of all the modules, it will no longer prompt you to enable the macros."

There were 2 modules under the Modules folder, 1 and 2. I right clicked on each, and the option available was "Remove Module 1...", which I did, and repeated for the 2nd. But the disable/enable macros pop up still appears. Suggestions?
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, scottie,
WELCOME to the Board !!!

where you had modules you have still some other kinda 'maps' above
one is called "forms"
another "microsoft excel objects"

are there userforms ?

is there code any or the sheetmodule ?
if you don't know what I'm talking about then
1. right click "Name Tab" of sheets
2. Select "View Code" in drop down menu
3. VBE window will open ... is there code ?[/size]

is there code in the "thisworkbook" module
if you don't know what I'm talking about then
1. Rightclick the little Excel-icon on the topleft of your page just beside the Filemenu
2. Select "View Code" in drop down menu
4. VBE window will open ... is there code[/size]

kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,118,018
Messages
5,569,652
Members
412,286
Latest member
kychemist00
Top