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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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" <bob....@somewhere.com> 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" <david.torre...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
> 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 <david.torre...@gmail.com> 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" <bob....@somewhere.com> 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" <david.torre...@gmail.com> wrote in message
>
> >news:(E-Mail Removed)...
> > 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 trying to do the same thing David. It appears that the State is
read-only. Have you figured out a fix?

Thanks
Danny

"David Torrejón" wrote:

> 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 <david.torre...@gmail.com> 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" <bob....@somewhere.com> 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" <david.torre...@gmail.com> wrote in message
> >
> > >news:(E-Mail Removed)...
> > > 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
>
>
>