共用方式為


Workbook.WindowResize Event (Excel)

Occurs when any workbook window is resized.

Syntax

expression .WindowResize(Wn )

expression A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Wn

Required

Window

The resized window.

Example

This example runs when any workbook window is resized.

Private Sub Workbook_WindowResize(ByVal Wn As Excel.Window) 
 Application.StatusBar = Wn.Caption & " resized" 
End Sub

請參閱

概念

Workbook Object

Workbook Object Members