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 sets the number of sheets automatically inserted into new workbooks.
Application.SheetsInNewWorkbook = 3