You can just use

Sheets.Add Type:= "C:\myTemplate.xlt"

Before seems to fail with this option, but you could move it afterwards.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David Coyle" <David wrote in message
...
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.