[發問] about Visible

bobomi

好比  ThisWorkbook 有 Workbook_Open 事件可以用

請問如果改變 Application.Visible 的值時, 有哪些事件可以用 ?

luhpro

好比  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

回復 2# luhpro


我也跟你一樣如此嘗試的

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