Prev: Excel 2007 Chart in VB6 Program
Next: Switching to a specific worksheet
From: HappySenior on 19 Jul 2008 12:07
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.
From: Wigi on 19 Jul 2008 14:16
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.
>
From: HappySenior on 19 Jul 2008 14:41
On Jul 19, 12:16 pm, Wigi <W...(a)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...
From: Wigi on 19 Jul 2008 14:46
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...(a)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...
>
From: Gord Dibben on 19 Jul 2008 17:33
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
<dwlawrence(a)centurytel.net> wrote:

>On Jul 19, 12:16�pm, Wigi <W...(a)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...

 |  Next  |  Last
Pages: 1 2
Prev: Excel 2007 Chart in VB6 Program
Next: Switching to a specific worksheet