Expand Minimize

Application.SheetsInNewWorkbook Property (Excel)

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

expression .SheetsInNewWorkbook

expression A variable that represents an Application object.

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

MsgBox "Microsoft Excel inserts " & _ 
 Application.SheetsInNewWorkbook & _ 
 " sheet(s) in each new workbook"
Show:
© 2015 Microsoft