當(dāng)指定的數(shù)據(jù)透視表視圖斷開(kāi)與數(shù)據(jù)源的連接時(shí),該事件發(fā)生。
Private Sub Form_OnDisconnect()
示例
下面的示例說(shuō)明了捕獲 OnDisconnect 事件的子程序的語(yǔ)法。
Private Sub Form_OnDisconnect()
MsgBox "The PivotTable View has " _
& "disconnected from its data source!"
End Sub