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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
696
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
326
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,348
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,118
Messages
5,835,495
Members
430,360
Latest member
Ajonode

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
Top