How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.

Go in design mode and then right-click the commandbutton to go to the
Properties.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"HappySenior" wrote:

> How do I add a commandbutton in Excel 2003 and modify its
> characteristics? I have pasted a commandbutton from the control group
> and modified its caption. I am not able to change its font name, size
> or make it bold.
> Also, how do I attach macro code to it to cause it to execute. I am
> trying to translate a task given to Excel 2007 users.
> Thank you.
>

On Jul 19, 12:16*pm, Wigi <W...@discussions.microsoft.com> wrote:
> Go in design mode and then right-click the commandbutton to go to the
> Properties.
>
> --
> Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music
>
>
>
> "HappySenior" wrote:
> > How do I add a commandbutton in Excel 2003 and modify its
> > characteristics? I have pasted a commandbutton from the control group
> > and modified its caption. I am not able to change its font name, size
> > or make it bold.
> > Also, how do I attach macro code to it to cause it to execute. I am
> > trying to translate a task given to Excel 2007 users.
> > Thank you.- Hide quoted text -
>
> - Show quoted text -

I am unable to locate design mode in Excel 2003...

It's the rules pictogram on the Visual Basic Toolbar.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"HappySenior" wrote:

> On Jul 19, 12:16 pm, Wigi <W...@discussions.microsoft.com> wrote:
> > Go in design mode and then right-click the commandbutton to go to the
> > Properties.
> >
> > --
> > Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music
> >
> >
> >
> > "HappySenior" wrote:
> > > How do I add a commandbutton in Excel 2003 and modify its
> > > characteristics? I have pasted a commandbutton from the control group
> > > and modified its caption. I am not able to change its font name, size
> > > or make it bold.
> > > Also, how do I attach macro code to it to cause it to execute. I am
> > > trying to translate a task given to Excel 2007 users.
> > > Thank you.- Hide quoted text -
> >
> > - Show quoted text -
>
> I am unable to locate design mode in Excel 2003...
>

Sounds like you created a button using the Forms Toolbar


Gord Dibben MS Excel MVP

On Sat, 19 Jul 2008 11:41:42 -0700 (PDT), HappySenior
<(E-Mail Removed)> wrote:

>On Jul 19, 12:16*pm, Wigi <W...@discussions.microsoft.com> wrote:
>> Go in design mode and then right-click the commandbutton to go to the
>> Properties.
>>
>> --
>> Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music
>>
>>
>>
>> "HappySenior" wrote:
>> > How do I add a commandbutton in Excel 2003 and modify its
>> > characteristics? I have pasted a commandbutton from the control group
>> > and modified its caption. I am not able to change its font name, size
>> > or make it bold.
>> > Also, how do I attach macro code to it to cause it to execute. I am
>> > trying to translate a task given to Excel 2007 users.
>> > Thank you.- Hide quoted text -
>>
>> - Show quoted text -
>
>I am unable to locate design mode in Excel 2003...

On Jul 19, 3:33*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Sounds like you created a button using the Forms Toolbar
>
> Gord Dibben *MS Excel MVP
>
> On Sat, 19 Jul 2008 11:41:42 -0700 (PDT), HappySenior
>
>
>
> <dwlawre...@centurytel.net> wrote:
> >On Jul 19, 12:16*pm, Wigi <W...@discussions.microsoft.com> wrote:
> >> Go in design mode and then right-click the commandbutton to go to the
> >> Properties.
>
> >> --
> >> Wigihttp://www.wimgielis.be=Excel/VBA, soccer and music
>
> >> "HappySenior" wrote:
> >> > How do I add a commandbutton in Excel 2003 and modify its
> >> > characteristics? I have pasted a commandbutton from the control group
> >> > and modified its caption. I am not able to change its font name, size
> >> > or make it bold.
> >> > Also, how do I attach macro code to it to cause it to execute. I am
> >> > trying to translate a task given to Excel 2007 users.
> >> > Thank you.- Hide quoted text -
>
> >> - Show quoted text -
>
> >I am unable to locate design mode in Excel 2003...- Hide quoted text -
>
> - Show quoted text -

Yes, my problem was using the wrong toolbar to add the commandbutton.
I never noticed the Visual Basic toolbar. Using that one, I was able
to change the font on the commandbutton and attach a macro. The
commandbutton works the work it is suppose to. Many thanks to all for
the total contribution! Don