Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
Creating a worksheet/template for Mileage | Excel Worksheet Functions | |||
Creating summary worksheet from template | New Users to Excel | |||
creating template | Excel Programming | |||
Creating a new worksheet from a template | Excel Discussion (Misc queries) |