Application.SheetsInNewWorkbook Property (Excel)
Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long.
Syntax
expression .SheetsInNewWorkbook
expression A variable that represents an Application object.
Example
This example displays the number of sheets automatically inserted into new workbooks.
MsgBox "Microsoft Excel inserts " & _
Application.SheetsInNewWorkbook & _
" sheet(s) in each new workbook"