Thank you. It's a great idea to have the sound files included with the Excel workbook. (Where are they? In what form--what do I need to know to transfer them to my worksheet?)
I saved the file on my Mac (an almost new MacBook Pro). Opened it in Excel 2011. Enabled macros. Saw the nice line-up of 5 buttons. Clicked one button, obtained dialogue box:
Microsoft Visual Basic
Run-time error '1004':
Cannot start the source application for this object. There may not be enough memory available. [Actually I have 8GB RAM, no other applications open, except the Finder.]
I clicked 'Debug' and saw this line in the macro code highlighted yellow:
My Excel 2011 is up to date.
I rebooted the computer, tried again. Same result.
The computer is not connected to the internet.
iTunes 10 is loaded (tho' I haven't loaded any music yet). It was not open when I tried your file and it did not automatically open.
I played around with your file (on a different computer), in Windows Excel 2003, and heard a single sound for the first button I clicked, then saw that iTunes had opened and 'clarry1' had been added to that iTunes music collection. But by then the buttons had become rectangles that did not function as buttons. Somewhat similar in Excel 2007, tho' I didn't hear a sound.
When I first clicked (in Excel 2003) a dialogue box warned 'You are about to activate an OLE object...' If I said yes, I heard the sound, first time only. If I said no, I got VB runtime error 1004 (Verb method of OLEObject class failed)--same error as on Mac.
I mention that Windows stuff, not because I'm asking for something that works in Windows, but in case it's more evidence that helps diagnosis.
Is there something I'm missing in what I'm doing in Excel 2011 in Mac?
The Y/N question about OLE in Excel 2003, and the similarity of the errors, suggests I may need to turn on some permission to use OLE, in Excel 2011?? Is that a relevant thought? If so, how do I do that? (I've never come across that issue, in my only 12 years labouring with Excel...)
John, I greatly appreciate your efforts.