共用方式為


Application.Ready Property (Excel)

Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready. Read-only Boolean.

Syntax

expression .Ready

expression A variable that represents an Application object.

Example

In this example, Microsoft Excel checks to see if the Ready property is set to True, and if so, a message displays "Application is ready." Otherwise, Excel displays the message "Application is not ready."

Sub UseReady() 
 
 If Application.Ready = True Then 
 MsgBox "Application is ready." 
 Else 
 MsgBox "Application is not ready." 
 End If 
 
End Sub

請參閱

概念

Application Object

Application Object Members