Share via

Application.SheetsInNewWorkbook Property

  • Article
Excel Developer Reference

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.

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

See Also