Hello Corey,

Here is the revised code...

Sub Macro1()
With ThisWorkbook
If .Worksheets.Count < 99 Then
Call Macro2
Exit Sub
End If
If .Worksheets.Count = 99 Then
..Worksheets(Array("Opening Page", "Template")).Copy
End If
End With
End Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=555333