i have this set of commands that generates a worksheet...BUT i want it to generate a TEMPLATE not just another worksheet, here is the path to the template and the SUB() that generates a worksheet .... just not sure where or how to place the path...
PATH= "C:\Documents and Settings\Microsoft\Templates\Analysis1.xlt"
------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
If Target.Count > 1 Then Exit Sub
Target.Value = UCase(Target.Value)
For Each ws In ThisWorkbook.Worksheets
If ws.Name = Target.Value Then Exit Sub
Next ws
shtName = Target.Value
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = shtName
Sheets("SYMBOL LIST").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
PATH= "C:\Documents and Settings\Microsoft\Templates\Analysis1.xlt"
------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
If Target.Count > 1 Then Exit Sub
Target.Value = UCase(Target.Value)
For Each ws In ThisWorkbook.Worksheets
If ws.Name = Target.Value Then Exit Sub
Next ws
shtName = Target.Value
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = shtName
Sheets("SYMBOL LIST").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub