Hello,

So I made a template sheet that I saved to %appdata%\Microsoft\Templates, so I select it when I right click the active sheet name -> insert > select my template.

However, I am looking to do one of those 2 things :

When I click the + to create a new sheet, I would like it to automatically add my template and today's date as the name of the sheet.

or

If I insert my template, automatically change the name of my new sheet with the template to today's date.

How can I do that ? I know nothing with VBA. I appreciate the help.