Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 364
Default command button question

i don't use command buttons very often, but i am wondering why sometimes i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify it.

what's the secret?

--


Gary



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default command button question

Sounds to me that sometimes you are creating buttons from the forms toolbar,
sometimes from the control toolbox. The former assigns macros to it, and is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 364
Default command button question

bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms toolbox.
so i try to use the control toolbox and that's where i have problems with
selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 111
Default command button question

Sounds like you are still in "Design mode". There is a green square in the
upper left hand corner of the toolbox. After you are done designing the
button, click on the square to get out of "Design mode".


"Gary Keramidas" wrote in message
...
bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms
toolbox. so i try to use the control toolbox and that's where i have
problems with selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary









  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default command button question

As I said in my previous reply, with control toolbox buttons, to modify you
need to be in design mode (click the green-blue triangle button on the
toolbar), and you then you need to exit design mode.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms

toolbox.
so i try to use the control toolbox and that's where i have problems with
selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why

sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all

4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
command button add another command Wanna Learn Excel Discussion (Misc queries) 5 December 7th 08 11:42 PM
2 part question - macro / command button John Excel Discussion (Misc queries) 3 April 16th 05 09:00 PM
Command Button Question Todd D. Levy Excel Programming 4 July 7th 04 03:18 PM
Command Button vs Control Button RGibson Excel Programming 1 October 14th 03 02:24 AM
Command Button vs Form Button T K Excel Programming 4 August 26th 03 07:26 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"