Application.SheetsInNewWorkbook Property

Syntax

expression.SheetsInNewWorkbook

expression A variable that represents an Application object.

Example

This example displays the number of sheets automatically inserted into new workbooks.

Visual Basic for Applications
`MsgBox "Microsoft Excel inserts " & _ Application.SheetsInNewWorkbook & _ " sheet(s) in each new workbook"`

Add more sheets on opening new workbook? Change how many sheets are automatically inserted into new workbook? Set default sheets to five. sheets sheets in new workbook Sheets In New Workbook Property sheetsin sheetsinnew SheetsInNewWorkbook SheetsInNewWorkbook Property What is the current default number of sheets in workbook?

Application.SheetsInNewWorkbook Property

Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long.

See also: