Automate deletion of macros

[Guest]

I use macros to import and sort data onto multiple sheets, and then to save the file under a new name. I do not want to save the macro in the new spreadsheet.

Any ideas ?

 

[JohnG]

You could copy the worksheet to a new work book and save that, it would not contain the macro.

On 2002-02-20 05:55, Anonymous wrote:
I use macros to import and sort data onto multiple sheets, and then to save the file under a new name. I do not want to save the macro in the new spreadsheet.

Any ideas ?