the workbook_Open event fires when a workbook is opened if the user does not
disable macros.

See Chip Pearson's page on events'
http://www.cpearson.com/excel/events.htm

for sounds:

http://support.microsoft.com/default...b;en-us;213777
XL2000: How to Play Sounds Using Visual Basic for Applications

http://support.microsoft.com/default...b;en-us;158140
XL: How to Play Sounds Using Visual Basic for Applications

http://support.microsoft.com/default...kb;en-us;86281
HOWTO: Play a Waveform (.WAV) Sound File in Visual Basic
[Contains the Constants for the Arguments]

http://support.microsoft.com/default...b;en-us;170730
WD: How to Play a .wav Sound File by Using a Macro

http://support.microsoft.com/default...b;en-us;211842
WD2000: How to Play a .wav Sound File Using a Macro

http://support.microsoft.com/default...b;en-us;193223
HOWTO: Use the MessageBeep API to Play System .WAV Files

--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
Is it possible to to create a macro that runs when you click on a
worksheet
tab to open it, or to change the scripting to achieve that action?

Specifically, we would like to have a *.wav file play when a worksheet is
opened.

Thanks,
--
DAS