This documentation is archived and is not being maintained.

SheetsInNewWorkbook Property [Excel 2003 VBA Language Reference]

Office 2003

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

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"
		


Applies to | Application Object


Show: