Playsound stops when another macro pressed

[txgent72]

Hello, I have an invoicing/ accounting program virtually complete. My eccentric guest asked for a jukebox with songs to play in a loop in the background while doing other tasks, which is mostly clicking macros to process data.
Trouble is, whenever another non-music macro is clicked, the music loop then stops.
Is there a way to keep the music going AND allow the calculation macro to work?
Thanks
Chris

 

[txgent72]

Note: using sndPlaySoundA method

 

[MEUserII]

Hello, I have an invoicing/ accounting program virtually complete. My eccentric guest asked for a jukebox with songs to play in a loop in the background while doing other tasks, which is mostly clicking macros to process data.
Trouble is, whenever another non-music macro is clicked, the music loop then stops.
Is there a way to keep the music going AND allow the calculation macro to work?
Thanks
Chris

If you're not already aware; the VBA command:

Application.Run "Macro_Name"

Can be placed at the end of your initial macro which will call the next macro; this should facilitate the guest not having to click macros to process data.
With regard to sndPlaySoundA method; I am not sure if aforementioned command will stop the music loop.

 

[txgent72]

Thank you for your reply, however, the workbook tabs have multiple macros each for my customer to press depending on which step they are working on in the invoice tab or data entry tab or accounting tabs.

It's not automatic because they enter transaction information over a period of a month to build the database. The system has no way of knowing when a user is ready for processing whatever macro to perform.

If I wanted something automatic I would just call a Function. I will include some screenshots to show sample code below:

 

[txgent72]

Hello, I have an invoicing/ accounting program virtually complete. My eccentric guest asked for a jukebox with songs to play in a loop in the background while doing other tasks, which is mostly clicking macros to process data.
Trouble is, whenever another non-music macro is clicked, the music loop then stops.
Is there a way to keep the music going AND allow the calculation macro to work?
Thanks
Chris

If user starts the program and turns on a song, it works great. They can listen to the song, but the second a button is pressed anywhere, even an excel button, the wav file stops and they have to go back to start it again or pick a new song. This is the last hurtle before release to my client.
I sincerely appreciate any help!

 

[txgent72]

The specific problem seems to be the scroll bar.

When I use the scroll bar, my macro to play the backround "elevator" music stops.

I don't understand why and it's really annoying.