Board logo

標題: [發問] about Visible [打印本頁]
作者: bobomi    時間: 2014-8-19 20:47     標題: about Visible

好比  ThisWorkbook 有 Workbook_Open 事件可以用

請問如果改變 Application.Visible 的值時, 有哪些事件可以用 ?
作者: luhpro    時間: 2014-8-19 23:54

好比  ThisWorkbook 有 Workbook_Open 事件可以用

請問如果改變 Application.Visible 的值時, 有哪些事 ...
bobomi 發表於 2014-8-19 20:47

Private Sub App_NewWorkbook(ByVal Wb As Workbook)
Private Sub App_SheetActivate(ByVal Sh As Object)
Private Sub App_SheetDeactivate(ByVal Sh As Object)
Private Sub App_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Private Sub App_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window)
Private Sub App_WindowDeactivate(ByVal Wb As Workbook, ByVal Wn As Window)
Private Sub App_WindowResize(ByVal Wb As Workbook, ByVal Wn As Window)
Private Sub App_WorkbookActivate(ByVal Wb As Workbook)
Private Sub App_WorkbookDeactivate(ByVal Wb As Workbook)
試過以上幾種都沒有觸發相關事件,
或者你把你的需求敘述一下,
看有沒有其他方法可以達成.
作者: bobomi    時間: 2014-8-20 08:11

回復 2# luhpro


我也跟你一樣如此嘗試的

若真沒有那我只好另寫一個處理的 Sub 來給外部呼叫



歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)