Prompt to enable/disable macros

[John]

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

 

[Tom Ogilvy]

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.

 

[pfsardella]

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

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

HTH
Paul

 

[Dave Peterson]

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

 

[John]

Thanks Tom, I did indeed.

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.