Sound Alert when cell content changes in a non active sheet

[mossey]

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?

[mossey]

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

[mossey]

'How to set a macro to an sheet-event by a macro

Prop(0).name = “EventType”

Prop(0).value = “Script”

Prop(1).name = “Script”

Prop(1).value = “vnd.sun.star.script:Standard.Quotes.OnSheetContentChange?language=Basic&location=document”



oTargetSheet.Events.replaceByName(“OnCalculate”, Prop())



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