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