Excellent and I am happy Dave came up with a better solution with the hidden
worksheet.


Gord

On Tue, 12 Feb 2008 08:48:09 -0800, Pugs wrote:

Nevermind,

I've sorted it out. Right now, my macros look like:

Sub NewSheet()
Sheets("Sheet").Select
Sheets("Sheet").Copy After:=Sheets(Sheets.Count)
End Sub

Sub HideSheetTemplate()
Sheet1.Visible = xlVeryHidden
End Sub

Sub ShowSheetTemplate()
Sheet1.Visible = True
End Sub

They're working beautifully. See! Sometimes us non-technical Project
Managers can accomplish something slightly technical!

"Pugs" wrote:

Dave,

This is an excellent solution! I'm playing with it right now. My only
complaint so far is I'm trying to figure out how to have newly created sheet
moved to be the last sheet.

With the sheet.copy function, you have to specify a sheet for it to be
inserted before or after. If you tell it to insert after Sheet3 (let's say
that this is the last sheet in the book), it will always insert after Sheet3.
So you insert one sheet new sheet and it inserts after Sheet3. You insert
another sheet and it inserts after Sheet3 again, but before the one the
previously inserted. Did that make sense?