Expose Workbook events via Excel JavaScript API
Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):
Activate,Deactivate
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetActivate,SheetDeactivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetChange
SheetSelectionChange

Glad to report that Many of the events asked here are GA!
please check this pageto see details;
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-events
We are still to provide (other are in, please try them!)
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetBeforeDoubleClick
SheetBeforeRightClick
thanks!
3 comments
-
Anusha commented
i want to Automatically refresh the workbooks when i make changes in workbook 1..should be automatically refreshed in workbook 2, when 2 tabs are already open.
currently i do not find any events for this until i create button and refresh it. -
Gary Miller commented
There are a couple of events that it would be nice to have that are currently available in the desktop version. For example Scroll events. Currently it is not possible to sync and AddIns UI with the Excel UI.
-
Danny commented
Same Events that exist on the Desktop version of Office applications should also be available on the web version of Excel and Word and accessible via Javascript