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
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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.
 
Upvote 0
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.
 
Upvote 0
In the VB editor, you need to remove the module that the macro was in as well as deleting the macro itself
 
Upvote 0
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:
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top