Microsoft KB Archive/102334

From BetaArchive Wiki


Excel: SOUND.PLAY() Results in Macro Error if Object Selected

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.

REFERENCES

"Function Reference," version 4.0, pages 415-416


KBCategory: kbole

KBSubcategory:

Additional reference words: 4.00 4.00a



Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.