Can I set an Audio alert in a Google spreadsheet cell that triggers whenever it changes a specific value?
I want some thing similar to "beepnow" function which is using in MS Excel VBA.
google sheets
Can I set an Audio alert in a Google spreadsheet cell that triggers whenever it changes a specific value?
I want some thing similar to "beepnow" function which is using in MS Excel VBA.
Best Answer
Short answer
At this time it's not possible to trigger an audio alert through an on edit event without opening and HTML sidebar or dialog.
Explanation
The equivalent to Excel VBA is Google Apps Script which is based on JavaScript. Unfortunately they don't include a class for sounds.
The answer by Mogsdad to the referred Stack Overflow question in a comment by user 79865 use the audio tag from HTML5, that could be used in an HTML side bar or dialog but not alone.