Deleting a macro?

M

MTC

Hello. I was working on a workbook when I accidentally
started to write a macro (I went to Tools - macro -
create new macro - clicked okay.) When I realized that
this was a mistake, I immediately stopped the recorder.
I then made a variety of changes to this workbook and
then had to save it several times, under a variety of
names. So when I went to open these workbooks, it said
that they contained a macro (I enabled them.)

I then went to Tools - Macro - macros - delete and
deleted all the macros that were listed (basically, one
for every workbook that I had saved.) I saved the
workbooks again, then went to reopen them again. But the
problem is that I am still getting the message that says
this workbook contains macros (I get it for each of the
workbooks.) But if I go to Tools - Macro - macros - and
select all open workbooks, it has no macros at all as
being in these workbooks! Why am I getting this message
that these workbooks contain macros when they really do
not? How can I make these messages go away (because I
will be sending these workbooks to other people and I
don't want them to be getting this message.) Thanks much
for any help you can give!
 
J

Jack Schitt

Try the following:
From the menu bar:
Tools/Macro/Visual Basic Editor
In the top left window (called "Project - VBAProject")
scroll down to where it shows "Module1"
Highlight Module1 then select from the menu bar:
File/Remove module1
Select "No" when prompted to export it first
Then re-save the workbook
 
Top