Sound in Excel

I want to play a simple sound if a certain condition is met in Excel. I've gotten this to work at my work computer (Office 365) by using a simple code:

Please Login or Register  to view this content.

The problem is when I pull up the spreadsheet on my computer at home, I get an error and am forced to delete the code in order for the spreadsheet to work.

If I understand correctly, this option was removed from recent versions of Excel which may be the reason, and I could use an alternative to play a .wav file, but that would require me to have a chosen .wav file in the same folder on each computer I wanted to run this on.

Is there any other way of doing this, or am I misunderstanding something?

Thanks!

Moderator Comment: I have added code tags to your post. Please re-read the forum rules you agreed to when you joined and abide by them in the future.

Maybe this will help: http://www.vbaexpress.com/kb/getarticle.php?kb_id=771

I can't test the function from the link as I can't get it to compile.

However, with the original function, this worked for me:

Formula:

Please Login or Register  to view this content.

Variations on a theme:

B1: =IF(A1=1,Beepme(),"")
B2: =IF(A2="x",Beepme(),"")
B3: =IF(A3=A1,Beepme(),"")

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.