Home

Template for Automatic Sheets in Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-851194%22%20slang%3D%22en-US%22%3ETemplate%20for%20Automatic%20Sheets%20in%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851194%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20a%20customized%20template%20to%20a%20workbook%20where%20the%20sheets%20are%20created%20as%20soon%20as%20the%20workbook%20has%20been%20opened.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20written%20the%20VBA%20code%20to%20create%20the%20sheet%20automatically%20upon%20opening.%20I%20have%20also%20created%20a%20template%20and%20saved%20it%20to%20XLStart%3B%20however%2C%20I%20cannot%20seem%20to%20get%20the%20two%20to%20work%20together.%20In%20other%20words%2C%20I%20want%20my%20custom%20template%20to%20populate%20in%20the%20automatically%20created%20sheet%20upon%20opening%20the%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20I%20can%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20best%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESG%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-851194%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
sassyginger
Occasional Visitor

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

Related Conversations