Skip to main content

Application.SheetsInNewWorkbook property

Table of contents
  1. Syntax
  2. Example

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



expression A variable that represents an Application object.


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

Application.SheetsInNewWorkbook = 3

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>