View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Coyle David Coyle is offline
external usenet poster
 
Posts: 1
Default 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.