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