removing macros

[scottie T]

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

 

[Russ At Index]

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]

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]

In the VB editor, you need to remove the module that the macro was in as well as deleting the macro itself

 

[scottie T]

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!!

 

[scottie T]

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]

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