Deleting a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently not well versed in Macro's for Excel.

One thing I'd like to know how to do is delete a Macro that I essentially
cannot find.

Here's what I did:


From there I went to Include >> Module [following the steps in Help]. But,
I then cancelled out of it by clicking on the close button [the X in top
right], and then closed the SpreadSheet [and saved when it asked].

But now when I start up it asks me if I want to enable Macros. When I do
enable them, and look through the Macros [Tools >> Macro >> Macros], I do not
see any Macros that I can delete.


So how can I delete a Macro / get that warning message to stop appearing?

I'm not concerned about the spreadsheet, I did this because I'm trying to
learn how to keep this warning from happening, but as it turns out I can't
figure it out.
Any help would be very much appreciated!
Thanks.

Scott
 
Remove the module

--
Don Guillett
SalesAid Software
(e-mail address removed)
scottech said:
I am currently not well versed in Macro's for Excel.

One thing I'd like to know how to do is delete a Macro that I essentially
cannot find.

Here's what I did:


From there I went to Include >> Module [following the steps in Help]. But,
I then cancelled out of it by clicking on the close button [the X in top
right], and then closed the SpreadSheet [and saved when it asked].

But now when I start up it asks me if I want to enable Macros. When I do
enable them, and look through the Macros [Tools >> Macro >> Macros], I do not
see any Macros that I can delete.


So how can I delete a Macro / get that warning message to stop appearing?

I'm not concerned about the spreadsheet, I did this because I'm trying to
learn how to keep this warning from happening, but as it turns out I can't
figure it out.
Any help would be very much appreciated!
Thanks.

Scott
Click to expand...
 
Scott

You must go back into the VB Editor and delete the empty module you created.

ALT + F11

CTRL + r

Select your workbook/project and expand.

Right-click on the module and "remove".

Click "no" when asked to export it.

ALT + Q to return to Excel window.

Save the workbook.


Gord Dibben Excel MVP

I am currently not well versed in Macro's for Excel.

One thing I'd like to know how to do is delete a Macro that I essentially
cannot find.

Here's what I did:


From there I went to Include >> Module [following the steps in Help]. But,
I then cancelled out of it by clicking on the close button [the X in top
right], and then closed the SpreadSheet [and saved when it asked].

But now when I start up it asks me if I want to enable Macros. When I do
enable them, and look through the Macros [Tools >> Macro >> Macros], I do not
see any Macros that I can delete.


So how can I delete a Macro / get that warning message to stop appearing?

I'm not concerned about the spreadsheet, I did this because I'm trying to
learn how to keep this warning from happening, but as it turns out I can't
figure it out.
Any help would be very much appreciated!
Thanks.

Scott
Click to expand...
 
Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros
I am currently not well versed in Macro's for Excel.

One thing I'd like to know how to do is delete a Macro that I essentially
cannot find.

Here's what I did:


From there I went to Include >> Module [following the steps in Help]. But,
I then cancelled out of it by clicking on the close button [the X in top
right], and then closed the SpreadSheet [and saved when it asked].

But now when I start up it asks me if I want to enable Macros. When I do
enable them, and look through the Macros [Tools >> Macro >> Macros], I do not
see any Macros that I can delete.

So how can I delete a Macro / get that warning message to stop appearing?

I'm not concerned about the spreadsheet, I did this because I'm trying to
learn how to keep this warning from happening, but as it turns out I can't
figure it out.
Any help would be very much appreciated!
Thanks.

Scott
Click to expand...
 
Thank you. Glad I found this thread.
I used to delete modules w/o a problem – couldn't just now.
Wasn't it easier to locate modules in older versions of Excel?
 
Versions prior to 97 used module sheets within Excel.

You just deleted the sheet.


Gord
 
Back
Top