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?