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:

On an excel sheet I've been working with, went to:
Tools Macro Visual Basic Editor.

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

"scottech" wrote in message
...
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:

On an excel sheet I've been working with, went to:
Tools Macro Visual Basic Editor.

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

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

On Mon, 7 Nov 2005 11:04:10 -0800, "scottech"
wrote:

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:

On an excel sheet I've been working with, went to:
Tools Macro Visual Basic Editor.

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

Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros

scottech wrote:

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:

On an excel sheet I've been working with, went to:
Tools Macro Visual Basic Editor.

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

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" wrote:
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

Versions prior to 97 used module sheets within Excel.

You just deleted the sheet.


Gord

On Sun, 4 Dec 2005 18:38:01 -0800, Caladonia
wrote:

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" wrote:
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