Sub test()
Dim n, i
n = 30
Application.SheetsInNewWorkbook = n
Workbooks.Add
For i = 1 To n
Sheets(i).Name = i
Next i
Application.SheetsInNewWorkbook = 3
End Sub
Sub test()
Dim n, i
n = 30
Application.SheetsInNewWorkbook = n
Workbooks.Add
For i = 1 To n
Sheets(i).Name = i
Next i
Application.SheetsInNewWorkbook = 3
End Sub