localized appears twice in the msgbox (/User Content.localized/Templates.localized/). With code you can find the correct path in Excel with this code line How do I find the template folder in 2016 and higher :
When you save as a template it automatically want to save in the default template folder. 1: Open a new workbook and delete all worksheets except the first one.Ģ: Change all the things you want in this worksheetģ: Then use File>Save As Template to save the file with the name you want as a Template (xlt, xltx or xltm).
