Microsoft KB Archive/102334

{| = Excel: SOUND.PLAY Results in Macro Error if Object Selected =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q102334 The information in this article applies to:
 * Microsoft Excel for Windows, versions 4.0, 4.0a

SYMPTOMS
In Microsoft Excel version 4.0 for Windows, a macro error will result if an object is selected when the SOUND.PLAY function is executed.

CAUSE
In Microsoft Excel version 4.0 for Windows, the SOUND.PLAY function will play a .WAV file or an embedded sound note in a spreadsheet if a sound card or speaker driver is present. If an object on the spreadsheet (such as a chart or text box) is selected at the time that the SOUND.PLAY function is executed, a macro error will result.

WORKAROUND
The SOUND.PLAY function will work properly if a cell or range is selected.

MORE INFORMATION
The SOUND.PLAY macro function plays the sound from a cell note or a file. It is equivalent to choosing the Note command from the Formula menu and choosing the Play button, or choosing the Note command from the Formula menu, choosing the Import button, and then choosing the Play button.