View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David Torrejón David Torrejón is offline
external usenet poster
 
Posts: 3
Default Custom button behaviour (activation and deactivation)

Thanks Bob,

I'm creating a simple example, changing the
CommandBars.ActionControl.State property to msoButtonDown, but when
the procedure finishes the button does not remain pressed. Is this the
normal behaviour?

Regards

On Jul 10, 8:05 pm, "Bob Phillips" wrote:
David,

You need the State property

With Application.CommandBars.ActionControl
.State = Not .State
End With

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"David Torrejón" wrote in message

oups.com...
Hello all,

I would like to add a custom button to an Excel toolbar (Excel 2003)
that could switch between activated and deactivated mode, that is to
say, the same behaviour as Bold, Align Left, Align Center, etc.
buttons, that remain pressed when the functionality is active.

Do you know whether it is possible?

Many thanks in advance

David Torrejón
Madrid, Spain