status bar with custom tool bar buttons
Hi, Frank!
Quote:
> Hi you all!
> In EXCEL7 there is a .StatusBar-property for custom tool
> bar buttons. I use this to assign text to be displayed in
> the status bar when the mouse cursor moves across my own buttons.
> I didn't manage this in EXCEL5, because the .StatusBar-property
> isn't known there (unlike the .ToolTips-property).
> Does somebody know a workaround? I don't want the default
> text (like "button to assign a user defined macro to" in my (German)
> version).
well, no, but this is done through the macro, itself. There are two ways:
manual and macro.
Manual:
1. Choose Tools, Macro and click ONCE on the macro.
2. Click on the Options button. Locate the Status Bar text field.
3. Enter your description. click OK to close and cancel out of the Run
menu.
When you assign the macro to a toolbar button, the statustext will display.
The macro version would look like this:
Application.MacroOptions Macro:="MyMacro", Description:= _
"Macro recorded 1/28/97 by George Atkins", HasMenu:=False, _
MenuText:="", HasShortcutKey:=False, Category:=14, StatusBar _
:="This shows up in the statusbar.", HelpContextID:="0", _
HelpFile:=""
Where macro:= is the name of the macro and StatusBar:= is the text to
display.
--
George K. Atkins
Iota Development Corporation
- he's been sick, but he's improving, folks!
