PC Review


Reply
Thread Tools Rate Thread

Re: Remove macro warning

 
 
Paul B
Guest
Posts: n/a
 
      1st Jul 2003
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" <(E-Mail Removed)> wrote in message
news:uzR$(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
 
 
 
Henry M
Guest
Posts: n/a
 
      2nd Jul 2003
Paul,

That worked! Thanks.

Henry

"Paul B" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:uzR$(E-Mail Removed)...
> > 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.
> >
> >

>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove macro warning Neil Perry Microsoft Excel Discussion 1 6th Oct 2008 10:44 AM
Still getting Macro Security Warning Message after removing Macro stef Microsoft Excel Discussion 3 16th Jun 2008 12:45 AM
remove macro and security warning =?Utf-8?B?bXV5Qk4=?= Microsoft Excel Programming 1 14th Mar 2007 12:57 AM
How do I remove the macro warning? =?Utf-8?B?Z2l6ZWxh?= Microsoft Powerpoint 1 31st Jan 2005 10:10 AM
Remove Macro warning message Dave Microsoft Excel Worksheet Functions 1 25th Sep 2003 06:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 AM.