Template for Automatic Sheets in Workbook

Copper Contributor

Good morning!

 

I am trying to add a customized template to a workbook where the sheets are created as soon as the workbook has been opened.

 

I have already written the VBA code to create the sheet automatically upon opening. I have also created a template and saved it to XLStart; however, I cannot seem to get the two to work together. In other words, I want my custom template to populate in the automatically created sheet upon opening the workbook. 

 

Does anyone know how I can do this?

 

All the best,

 

SG

0 Replies