software

Macro no longer wanted, was deleted, and isn't in macro list but every time
file opened enable or disable macro comes up. I need to know how to get rid
of the macro. Thanks

You need to delete the module that contained the macro. Even an
empty module can cause the macro alert message.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Jane Makinsonquot; lt;Jane gt; wrote
in message
...
gt; Macro no longer wanted, was deleted, and isn't in macro list
gt; but every time
gt; file opened enable or disable macro comes up. I need to know
gt; how to get rid
gt; of the macro. Thanks
Thank you for swift reply, but how do I delete the module? I'd created a
simple macro in a workbook then decided I no longer needed it. I have created
a number of new files on from the original and deleted macro in all versions
from macro list but it still seems to be there somewhere. Thanks

quot;Chip Pearsonquot; wrote:

gt; You need to delete the module that contained the macro. Even an
gt; empty module can cause the macro alert message.
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Jane Makinsonquot; lt;Jane gt; wrote
gt; in message
gt; ...
gt; gt; Macro no longer wanted, was deleted, and isn't in macro list
gt; gt; but every time
gt; gt; file opened enable or disable macro comes up. I need to know
gt; gt; how to get rid
gt; gt; of the macro. Thanks
gt;
gt;
gt;

Open the VBA Editor (ALT F11). There, display the Project
Explorer window (CTRL R). You should see your workbook in that
tree view. Open your project's quot;folderquot;, and look for a
quot;subfolderquot; called Modules. Expand that node of the tree view and
right-click on each item in the folder and choose Remove,
clicking 'No' to the quot;Do you want to export?quot; prompt.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Jane Makinsonquot; gt; wrote in
message
...
gt; Thank you for swift reply, but how do I delete the module? I'd
gt; created a
gt; simple macro in a workbook then decided I no longer needed it.
gt; I have created
gt; a number of new files on from the original and deleted macro in
gt; all versions
gt; from macro list but it still seems to be there somewhere.
gt; Thanks
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; You need to delete the module that contained the macro. Even
gt;gt; an
gt;gt; empty module can cause the macro alert message.
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;Jane Makinsonquot; lt;Jane gt;
gt;gt; wrote
gt;gt; in message
gt;gt; ...
gt;gt; gt; Macro no longer wanted, was deleted, and isn't in macro list
gt;gt; gt; but every time
gt;gt; gt; file opened enable or disable macro comes up. I need to know
gt;gt; gt; how to get rid
gt;gt; gt; of the macro. Thanks
gt;gt;
gt;gt;
gt;gt;