Playing a .wav IF a condition...

Hi, I'm trying to add a .wav sound to all cells in a column if it equals "! ALERT !" or "! WARN !" etc. I have created a macro and added the following code:

Please Login or Register  to view this content.

This works for the first cell in the column and I'm assuming I'll to add a loop within it to apply the same to the rest of the column cells. I would also like to reference .wav files in other files but using c:\BERT\BEAM-ME-UP-SCOTTY doesn't work? How do I do this and is it something to do with the FILEPATH?

This is my first macro and I would appreciate help in achieving this, please help. I have posted this problem before but not had a solution yet!!!

The file is attached, I have applied some conditional formatting to highlight problems etc.

BERT.xls

Many thanks

J

AndyLitch, suggested this but...

Please Login or Register  to view this content.

...but no sound!?

Thanks

J