Toolbar buttons how do show and change the status

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a new toolbar to a sheet and I want to have the buttons show if
they were last depressed. I tried to use the toolbars.Toolbarbuttons.pushed
= True command but it gives me a type mismatch error. Any ideas on how to use
the command?
 
You need to toggle the state of the button something like this...

Application.CommandBars("My Toolbar").Controls("My Button").State =
msoButtonUp
or msoButtonDown
where the button was created using
..Controls.Add(msoControlButton)
 
Jim Thomlinson said:
You need to toggle the state of the button something like this...

Application.CommandBars("My Toolbar").Controls("My Button").State =
msoButtonUp
or msoButtonDown
where the button was created using
.Controls.Add(msoControlButton)
Click to expand...
 
I think I'm working on the same problem. I attempted to do as you said, but
don't have a "State" option. I created the buttons using customize toolbars.
They are set to run some macros that I've written. I'm running Office 2003
if that makes a difference.

Thanks for your help.
 
Back
Top