Toolbar buttons how do show and change the status
 

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?

Toolbar buttons how do show and change the status
 

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)
--
HTH...

Jim Thomlinson


"Ed Vesely" wrote:

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?