creating a new worksheet from a template using VBA
Hi,
I am having a problem creating a worksheet from a template using a
click-button.
Private Sub cmdNewWorksheet_Click()
Worksheets.Add Befo=Worksheets("Finish")
Worksheets(Worksheets.Count - 1).Name = txtNewWorksheet.Text
txtNewWorksheet.Text = ""
End Sub
I have a template set up, template1.xlt, with a worksheet created in this
called template.
Does anyone have any ideas?
Any help will be much appreciated.
Thank you in advance.
|