Prompt to enable/disable macros

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Thanks Tom, I did indeed.


Tom Ogilvy said:
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.
Click to expand...
 
Back
Top