Create new worksheet from template file in Excel
I am trying to figure out how to do the following:
In an existing workbook, double click a specific cell which will load a specific template file into a new worksheet and name the new tab the same as the text that was in the cell I double clicked.
Any help is appriciated.
Thank you,
Garrett
Re: Create new worksheet from template file in Excel
You'd need to capture the double click event on the cell.
Verify that the cell has a name.
Verify that the sheet name doesn't already exist.
Open the template.
Copy the sheet (renaming as you go).
Re: Create new worksheet from template file in Excel
Thanks Ecniv.
Does anyone have any examples or a site that I can learn from? I'm new to VB in excel.
Thanks