Excel: Modifying the Status Bar for a Custom Button

ID: Q84862


The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0


SUMMARY

You cannot add custom messages to the status bar when you do the following to manually add a custom button to a toolbar in Microsoft Excel:

  1. From the Options menu, choose Toolbar.


  2. Select Customize menu options.



WORKAROUND

To assign a message or help text to the custom button, you must create a macro that calls the ADD.TOOL() function.


MORE INFORMATION

When a custom tool is manually added to a toolbar, there is no provision for assigning a custom message that would appear in the status bar when the button is chosen. The default message is "Blank tool for assigning a macro." A macro using the ADD.TOOL function must be used to assign a message to the custom button.


REFERENCES

"User's Guide 2," version 4.0, pages 154-188
"Function Reference Guide," version 4.0, pages 11-12

Additional query words:

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 24, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.