Good Morning Everyone,
Thanks for taking the time to look at this one.
I have attached a worksheet and would really appreciate help with the following:
1. I need an audio alert to be triggered when one cell value in the range (A11:M11) is greater than or equal to 50.
2. I also need an audio alert to be triggered when one cell value in the range (A11:M11) is less than or equal to -50.
The numbers are generated through a dynamic data feed.
The audio alert can be the same sound for both values (e.g. "C: Windows Media Ring 03" is the location of one sound on my computer).
Could somebody please create a macro for this, and paste it in so that it runs automatically from when I open the document?
Alternatively, if it is possible (and easier) to do this using conditional formatting, please feel free to do so.
Looking forward to receiving your answers!
Bookmarks