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

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

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

I'm analyzing using the Watch Window and when I assing the
msoButtonDown to the ...ActionControl.State property the value does
not change, and the msoButtonUp value remains. However, if other
properties like the Caption does change.

Do you know if this property could be locked for some reason?

Thanks again
On Jul 10, 8:50 pm, David Torrejón wrote:
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

roups.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