Re: Remove macro warning

Henry, with you work book open hit Alt and F11 to open the vba editor, you
will then need to delete any modules that are under your workbook name, when
you have done that hit alt and Q to return you to your workbook and then
save it and close it, when you open it the macro warning should not come up,
if it does post back

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Henry M" <henry@recurrentresources.com> wrote in message
news:uzR$WhBQDHA.3768@tk2msftngp13.phx.gbl...
> I once put a macro in an Excel program, but have since deleted it.
However,
> every time I open this program, I still get a warning that this program
> contains macros, with option to "Disable Macros", Enable Macros", or "More
> Info". Obviously Excel thinks my programs still has macros. How do I
make
> sure all the macro are gone and get rid of this warning? There are no
> macros listed in this program when I go to Tools / Macro / Marcos. I need
> to share this program with others, and this Warning message confuses them.
>
> Henry M.
>
>

Paul,

That worked! Thanks.

Henry

"Paul B" <newspab@surfbest.net> wrote in message
news:#JeqbBCQDHA.2676@TK2MSFTNGP10.phx.gbl...
> Henry, with you work book open hit Alt and F11 to open the vba editor, you
> will then need to delete any modules that are under your workbook name,
when
> you have done that hit alt and Q to return you to your workbook and then
> save it and close it, when you open it the macro warning should not come
up,
> if it does post back
>
> --
> Paul B
> Always backup your data before trying something new
> Using Excel 2000 & 97
> Please post any response to the newsgroups so others can benefit from it
> ** remove news from my email address to reply by email **
> "Henry M" <henry@recurrentresources.com> wrote in message
> news:uzR$WhBQDHA.3768@tk2msftngp13.phx.gbl...
> > I once put a macro in an Excel program, but have since deleted it.
> However,
> > every time I open this program, I still get a warning that this program
> > contains macros, with option to "Disable Macros", Enable Macros", or
"More
> > Info". Obviously Excel thinks my programs still has macros. How do I
> make
> > sure all the macro are gone and get rid of this warning? There are no
> > macros listed in this program when I go to Tools / Macro / Marcos. I
need
> > to share this program with others, and this Warning message confuses
them.
> >
> > Henry M.
> >
> >
>
>