SheetsInNewWorkbook Property

Applies To

Application Object.

Description

Returns or sets the number of sheets Microsoft Excel automatically inserts in new workbooks. Read-write.

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"