MXL5: "Not Enough Memory" Using SHOW.BAR Function in Macro

Last reviewed: February 3, 1998
Article ID: Q133334
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel for the Macintosh, version 5.0, when you use the SHOW.BAR() function in a macro, you may receive the following error message

   Not enough memory.
   Continue without Undo?

followed by the following error message:

   Not enough memory

When you click OK in these error messages, the active macro sheet may not be redrawn completely.

CAUSE

This behavior occurs when you use the SHOW.BAR function in a Microsoft Excel version 4.0 Macro sheet with a bar_num argument value of 7, 8, or 9.

The SHOW.BAR function displays the menu bar specified by the bar_num argument. The bar_num argument values 7-9 are reserved for shortcut menus and are not valid values to use with the SHOW.BAR function.

Although these are not valid values for the bar_num argument, you should not receive a "Not enough memory" error message when you use the SHOW.BAR function with these values. When you run a macro in Microsoft Excel for Windows that contains the function SHOW.BAR() with a bar_num argument value of 7, 8, or 9, a macro error is returned as expected.

WORKAROUND

To avoid this problem, use the SHOW.BAR function with valid argument values, such as 1-6 and 10-12. For more information about the context for using these arguments, see the SHOW.BAR topic in Microsoft Excel Macro Functions Help.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about SHOW.BAR, choose the Search button in MS Excel Macro Functions Help and type:

   SHOW.BAR function


Additional query words: 5.00 5.00a XL5
Keywords : kbmacro kbprg xlmac PgmOthr
Version : MACINTOSH:5.0,5.0a
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbfix


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: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.