Separate your code into a different workbook and keep the template for the just
the data.


Kate wrote:

Hi, I have an excel spreadsheet which I'm using as a template. It has a
macro which imports data from elsewhere and reformats it. When the
macro is finished, I want the user to use save as to save the worksheet
under a different permanent name.

However, I dont want the results from the macro to be saved on the
template. (But I dont really want the user to have to delete them
either).

How do you fix this?

Thanks

--

Dave Peterson