I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.

I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

For instance once the user clicks continue, the hyperlink will take them to
the next worksheet where the sound file will play:

'This test is 1 hour long and there are 9 sections. It is multiple choice
etc.'

Can anybody give me a dummies (and I mean dummies!) guide to how to do this!

Look he http://www.j-walk.com/ss/excel/tips/tip59.htm
And/or Google with: Excel Sound
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Johno" wrote in message
...
I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.

I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

For instance once the user clicks continue, the hyperlink will take them
to
the next worksheet where the sound file will play:

'This test is 1 hour long and there are 9 sections. It is multiple choice
etc.'

Can anybody give me a dummies (and I mean dummies!) guide to how to do
this!

"Bernard Liengme" wrote:

Look he http://www.j-walk.com/ss/excel/tips/tip59.htm
And/or Google with: Excel Sound
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Johno" wrote in message
...
I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.

I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

For instance once the user clicks continue, the hyperlink will take them
to
the next worksheet where the sound file will play:

'This test is 1 hour long and there are 9 sections. It is multiple choice
etc.'

Can anybody give me a dummies (and I mean dummies!) guide to how to do
this!




I noticed this however I don't understand some of it of how to make it play
automatically and how to put the code into the worksheet.

More help would be appreciated.

Here's another brief description of how to do it:

http://www.cpearson.com/excel/excelM.htm#PlayWAV

Chip's site also has many tutorials on using VBA - use the Topic
Index.

Hope this helps.

Pete

On Jul 13, 9:26 pm, Johno wrote:
"Bernard Liengme" wrote:
Look hehttp://www.j-walk.com/ss/excel/tips/tip59.htm
And/or Google with: Excel Sound
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Johno" wrote in message
...
I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.

I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

For instance once the user clicks continue, the hyperlink will take them
to
the next worksheet where the sound file will play:

'This test is 1 hour long and there are 9 sections. It is multiple choice
etc.'

Can anybody give me a dummies (and I mean dummies!) guide to how to do
this!

I noticed this however I don't understand some of it of how to make it play
automatically and how to put the code into the worksheet.

More help would be appreciated.- Hide quoted text -

- Show quoted text -

I still can't work it out. How do I add the macro into the worksheet?

See David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Johno" wrote in message
...
I still can't work it out. How do I add the macro into the worksheet?

I really don't get this. It keeps erroring all the time.

It adds sub etc. and I really don't understand.