THANKS FOR THE LINK, BUT i STILL CAN'T GET IT ERROR PROOF
"Tom Ogilvy" wrote:
You want it to play everytime there is a recalculation and the cell
continues to show 100?
http://www.j-walk.com/ss/excel/tips/tip87.htm
--
Regards,
Tom Ogilvy
"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel
the macro to run when =IF(A1<=B1,100,0) gives an answer of 100
(and for all other calculations to continue when it is playing if
possible!?!)