Problem with Italophile’s reply is, no matter how hard I try, it will not save it in my Excel folder. It insists on saving it to C:\Users\User\Documents\Custom Office Templates. I have to drag it kicking and screaming to my folder.



When I create a sheet and click save, it defaults to saving it as the template. In word it defaults to a save as. Even though I launch the template from my Excel folder, the default location is back in C:\Users\User\Documents\Custom Office Templates.

I would have to create a templte.xls file with the name template and force myself to do a save as.

As for Logit’s solution, although it looks professional, I haven’t got a clue how to do this. I am well proficient in basic and VB.Net though. I have used codeing in Excel.