using sound in excel

my boss really likes to micro-manage so i would like to mess with him.

how would i go about adding sound when you select a page of a wook book?

thanks for the help in advance

Originally Posted by VBA Noob

Right click the sheet tab > select view code > paste in the below.

When that sheet is activated it will beep

Please Login or Register  to view this content.

or try link
http://spreadsheetpage.com/index.php...nd_from_excel/
VBA Noob

i got the beep to work but i was looking for exactly what was on the link

i am having trouble getting it to play. i pasted it in VBA and changed teh file name to match the wav file and no sound, i made sure that the wave file and workbook were in the same directory???

Please Login or Register  to view this content.

I don't know if this is true but I certainly smiled when I read this article.
http://www.excelguru.ca/blog/2008/05...e-of-vba-ever/

And I laughed out loud when I tried this:

Private Sub Worksheet_Change(ByVal Target As Range)
'Author : Ken Puls (www.excelguru.ca)
'Macro Purpose: Read aloud any values entered into the worksheet
' Application.Speech.Speak Target.Value
Application.Speech.Speak "Error: You fat-fingered the value... try exercising"
End Sub

It will probably wast a few minutes around the office
//Ola


The quotes comes from Danny's comment:
"Error: There are no consonants in a dollar amount"
"Error: Nice try, why don't you take a break and try again later"
"Error: You fat-fingered the value... try exercising"

i love it, now if i can just find it for a tab instead of a value i would be on it.

thanks everyone for the help

Press Alt+F11 and paste the code in Sheet1 to play only in Sheet1.
//Ola

Someone might contribute to a randomizer or delay between two messages, to spice up the surprise.

i understand that but i was hoing to find something that would play when you selected sheet2 even if you didnt edit any cell but just by selecting that sheet