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