1 open事件
2.beforeclose
’下面代碼使得程序不會(huì)被關(guān)閉，只能手工運(yùn)行代碼關(guān)閉
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub
3.禁止打印
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "禁止打印"
Cancel = True
End Sub
4.禁止插入新的工作表
5.beforesave
6.workbookactive
設(shè)計(jì)小程序時(shí)候出現(xiàn)自定義菜單懂扼。當(dāng)焦點(diǎn)轉(zhuǎn)移時(shí)候需要把菜單恢復(fù)或者刪除
7workbookdeactive
8workbook slection change
該代碼使用于workbook下所有的sheet表
