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



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

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