Microsoft KB Archive/84862

{|
 * width="100%"|

Excel: Modifying the Status Bar for a Custom Button

 * }

-

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 &quot;Blank tool for assigning a macro.&quot; A macro using the ADD.TOOL function must be used to assign a message to the custom button.