I have created an Excel 2003 template file and a macro assigned to a toolbar button. The macro saves the template as a CSV file (hotfile.csv) and closes the application. The next time I open the template file (hotfile.xlt), I click on the macro button and it tells me that it can't find the hotfile.csv macro.
What happens is the macro button is re-assigned to the CSV file during the SaveAs process.
How can I keep the macro assigned to the toolbar button in the template (Hotfile.xlt)?