다음을 통해 공유


Workbook.NewSheet Event (Excel)

Occurs when a new sheet is created in the workbook.

Syntax

.NewSheet(Sh)

A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Sh

필수

Object

The new sheet. Can be a Worksheet or Chart object.

Return Value

Nothing

Example

This example moves new sheets to the end of the workbook.

Private Sub Workbook_NewSheet(ByVal Sh as Object) 
 Sh.Move After:= Sheets(Sheets.Count) 
End Sub

참고 항목

개념

Workbook Object

Workbook Object Members