2006年11月12日
Excel VBA Event
Workbookを閉じる前のEvent@ThisWorkbook
Private Sub Workbook_BeforeClose(Cancel As Boolean)
End Sub
Workbookを保存する前にのEvent
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
End Sub
Workbookを開く時のEvent
Private Sub Workbook_Open()
End Sub
Sheetを切り替えるEvent
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
End Sub
WindowをActiveする/切り替えるEvent
Private Sub Workbook_WindowActivate(ByVal Wd As Window)
End Sub
WindowをDeActiveする/切り替えるEvent
Private Sub Workbook_WindowDeactivate(ByVal Wd As Window)
End Sub
- by
- at 17:43
comments