Hi,

I have a piece of code that generates some sheets and saves the file as
another file but strips out the code for macros.

However, when I open the new file (without the macros) I still get prompted
to enable/disable macros. However, when I look for the vba code it is indeed
removed and there is no macros listed in the run macro dialog box.

Any ideas??

Thanks
John

you probably have a space or something in one of your sheet modules.

Or, you have removed the code from general modules, but left the modules.
You would need to remove those as well.

--
Regards,
Tom Ogilvy


John wrote in message
...
Hi,

I have a piece of code that generates some sheets and saves the file as
another file but strips out the code for macros.

However, when I open the new file (without the macros) I still get
prompted
to enable/disable macros. However, when I look for the vba code it is
indeed
removed and there is no macros listed in the run macro dialog box.

Any ideas??

Thanks
John

Debra Dalgleish has a WebPage that details how to eliminate this
problem.

http://www.contextures.com/xlfaqMac.html#NoMacros

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Sat, 27 Sep 2003 13:26:13 +0000 (UTC), "John"
wrote:

Hi,

I have a piece of code that generates some sheets and saves the file as
another file but strips out the code for macros.

However, when I open the new file (without the macros) I still get prompted
to enable/disable macros. However, when I look for the vba code it is indeed
removed and there is no macros listed in the run macro dialog box.

Any ideas??

Thanks
John

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

John wrote:

Hi,

I have a piece of code that generates some sheets and saves the file as
another file but strips out the code for macros.

However, when I open the new file (without the macros) I still get prompted
to enable/disable macros. However, when I look for the vba code it is indeed
removed and there is no macros listed in the run macro dialog box.

Any ideas??

Thanks
John

--

Dave Peterson

Thanks Tom, I did indeed.


"Tom Ogilvy" wrote in message
...
you probably have a space or something in one of your sheet modules.

Or, you have removed the code from general modules, but left the modules.
You would need to remove those as well.

--
Regards,
Tom Ogilvy


John wrote in message
...
Hi,

I have a piece of code that generates some sheets and saves the file as
another file but strips out the code for macros.

However, when I open the new file (without the macros) I still get
prompted
to enable/disable macros. However, when I look for the vba code it is
indeed
removed and there is no macros listed in the run macro dialog box.

Any ideas??

Thanks
John