WAV file to play on opening a worksheet

[johnpdavey]

hi.

I would like to play a small wav file each time a worksheet is opened.

I have a workbook with 16 worksheets in which i have set up an interactive game on the lines of 'who wants to be a millionaire'.

The worksheets represent an intro page then 15 worksheets containing the questions / playing area for the £100, £200 ....£1 million questions.

I have a small wav file called 'new question' which plays the theme music.

I would like the wav file to be part of the workbook so that i can share the game with my colleagues and i would like it to play when the tab for each new question (worksheet) is selected.

I have read several posts on wav files in excel but am sorry to say i didn't understand any of them.
I am a complete novice at vba and have no idea what most of the expressions ment or which to adjust to fit my situation.

Can someone please therefore give me very simple step by step instructions on

1 how to put the wav file into my workbook

2 how to set things up so that it plays each time a worksheet tab is selected.

thank you in advance for your assistance
john