Sound Alert when cell content changes in a non active sheet

asked 2020-02-14 13:14:24 +0100

mossey gravatar image

I can sound alerts when content changes - no problem - but only when the sheet is currently active. is it possible to make sounds when the sheet is not active or when the application is not in focus?

edit retag flag offensive close merge delete


I tried OnCalculate eent. Anyone proide an API url, example or solution?

mossey gravatar imagemossey ( 2020-02-18 00:15:22 +0100 )edit

Prop(0).name = "EventType"
Prop(0).value = "Script"
Prop(1).name = "Script"
Prop(1).value = ""

oTargetSheet.Events.replaceByName("OnCalculate", Prop())

'Event names available: "OnFocus", "OnUnfocus", "OnSelect", "OnDoubleClick", "OnRightClick", "OnChange","OnCalculate"

mossey gravatar imagemossey ( 2020-02-18 00:18:08 +0100 )edit