I am creating several sheets for a project, what they do is track working hours and display the projected costs of operation for the day.
What I would like is for when the total number is negative for a wav file to play, such as bad.wav. Ideally I would like the good sound to play, but what I have found is that it continuosily goes because the numbers are positive as they are input.
I am not sure if there is a way to only play the sound once all cells have something in them?either way, I have it where I can play the sad.wav, but the issue is, each office has a different computer and we can't save files to them, the file would need to be embedded in the spreadsheet and the vba to point to the embedded file.i am on mobile at the moment but can add the formula I have later on this afternoon after the meeting of needed. I did attach a photo of the code I am currently using.
Bookmarks