您目前已離線,請等候您的網際網路重新連線

活頁簿和工作表的應用程式事件 XL97: 摘要

重要:本文是以 Microsoft 機器翻譯軟體翻譯而成,而非使用人工翻譯而成。Microsoft 同時提供使用者人工翻譯及機器翻譯兩個版本的文章,讓使用者可以依其使用語言使用知識庫中的所有文章。但是,機器翻譯的文章可能不盡完美。這些文章中也可能出現拼字、語意或文法上的錯誤,就像外國人在使用本國語言時可能發生的錯誤。Microsoft 不為內容的翻譯錯誤或客戶對該內容的使用所產生的任何錯誤或損害負責。Microsoft也同時將不斷地就機器翻譯軟體進行更新。

按一下這裡查看此文章的英文版本:161761
本文已封存。本文係以「現狀」提供且不會再更新。
本文章的有 Microsoft Excel 2002] 版本請參閱 291294
本文章的有 Microsoft Excel 2000] 版本請參閱 213220
結論
本文包含在舊版本的 Microsoft Excel 應用程式的活頁簿和工作表事件與每個相對應的指令用 Visual Basic 的摘要。
其他相關資訊

活頁簿事件

                    Previous version Event name         equivalent         Description of when event fires -----------------  -----------------  -------------------------------- Activate           Auto_Activate      When the active workbook changes                                       from another workbook to this                                       workbook. Deactivate         Auto_Deactivate    When the active workbook changes                                       from this workbook to another                                       workbook. Open               Auto_Open          When the workbook opens. BeforeClose        Auto_Close         Before the workbook closes. AddInInstall       Auto_Add           When the user Installs the Add-In                                       via the Add-In manager. AddInUninstall     Auto_Remove        When the User Uninstalls the Add-In                                       via the Add-In manager. WindowResize       N/A                After a window of the Workbook has                                       been opened, resized, maximized, or                                       minimized. WindowActivate     OnWindow           Every time the focus comes to a                                       Window belonging to the Workbook. WindowDeactivate   OnWindow           Every time the focus leaves this                                       particular window of the Workbook. BeforeSave         OnSave             Before a workbook saves. BeforePrint        N/A                Before a workbook prints. NewSheet           N/A                After a new sheet is created. SheetActivate      OnSheetActivate    Every time a sheet is activated in                                       the Workbook. SheetDeactivate    OnSheetDeactivate  After a sheet is deactivated in the                                       Workbook. SheetCalculate     OnCalculate        After any recalculation in the                                       Workbook. SheetBefore DoubleClick        OnDoubleClick      When a worksheet cell is double-                                       clicked. SheetSelection Change             N/A                When there's any change in cell                                       selection on a particular sheet. SheetBefore RightClick         N/A                When a worksheet cell is right-                                       clicked. SheetChange        OnEntry            When a user changes the formula                                       of a cell by typing, copy or paste,                                       drag or drop, or undo.   SetLinkOnData      OnData             When a DDE link is updated.				

工作表事件

                    Previous version Event name         equivalent         Description of when event fires -----------------  -----------------  ------------------------------- Activate           OnSheetActivate    When the active sheet changes                                       from another sheet to this sheet. Deactivate         OnSheetDeactivate  After the active sheet changes from                                       this sheet to another sheet. Fires                                       before the activated sheet displays. Calculate          OnCalculate        After every recalculation of this                                       sheet. BeforeDoubleClick  OnDoubleClick      When a worksheet cell is double-                                       clicked. SelectionChange    N/A                When a worksheet cell is clicked. BeforeRightClick   N/A                When a worksheet cell is                                       right-clicked. Change             OnEntry            When a user changes the formula                                       of a cell by typing, copy or paste,                                       drag or drop, or undo.				
参考
如需有關活頁簿或工作表的事件的詳細資訊,按一下 Visual Basic 說明中的 [索引] 索引標籤,鍵入下列文字
事件
然後再連按兩下所選取的文字,以移至事件程序主題。
97 xl97 8.00

警告:本文為自動翻譯

內容

文章識別碼:161761 - 最後檢閱時間:10/04/2013 18:18:11 - 修訂: 1.0

Microsoft Excel 97 Standard Edition

  • kbnosurvey kbarchive kbmt kbprogramming KB161761 KbMtzh
意見反應