VBA BeforeSave can't save in Macro Enabled Template

Hi,
I am an absolute beginner, Excel and VBA, but am great at ‘just in time’ learning. I’ve created a 2010 Macro Enabled Template with formulas and VBA code I found/adapted, shared so generously online. I am stuck at what is probably something so very basic but cannot find information on it after hours of searching.

The VBA Code in ThisWorkbook, Private Sub Workbook Open and Private Sub Workbook BeforeClose, both work wonderfully. I am trying to add Private Sub Workbook BeforeSave code that I found, between the two other Subs, which forces the user to save the new document created as a Macro Enabled Workbook with today’s date (user will manually append the rest of the name with the relevant information).

But, when I try to re-save the Template with the BeforeSave code in the Macro Enabled Template format, it only offers me the Macro Enabled Workbook format – quite logical, of course!

How do I bypass it the one time to save the new code into the Template format? Any explanation would be very much appreciated, thanks Lillian

Can you post a sample workbook?
Click "Go Advanced" and scroll down to select "Manage Attachments"
From there click "Add Files" and upload a sample workbook
be sure to remove sensitive information

Thank you, appreciate your help!