Automate deletion of macros

Feb 20th, 2002, 06:55 AM

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 · Feb 20th, 2002, 07:11 AM

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

Quote:

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 ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 06:55 AM	#1
Guest Posts: n/a	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 ?