Deleting a macro

[scottech]

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

 

[Don Guillett]

Remove the module

--
Don Guillett
SalesAid Software
(e-mail address removed)

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

 

[Gord Dibben]

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

 

[Dave Peterson]

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

 

[Caladonia]

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?

 

[Gord Dibben]

Versions prior to 97 used module sheets within Excel.

You just deleted the sheet.


Gord