If Int(Val(Application.Version)) >= 15 Then Note : The library folder is a hidden folder, press the Option key when you click on Go in the Finder menu to see/open this folder. On my Dutch Mac in Finder User Content/Templates show up as Gebruikersinhoud/Sjablonen On my English Mac the folder location in Finder is : /Users/rondebruin/Library/Group Containers/UBF8T346G9.Office/User Content/Templates You don’t see these in Finder because by default the Finder suppresses extensions while VBA shows the raw folder names, in English.” 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).

Excel spreadsheet templates for mac