Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Control Toolbox toolbar

Friends,

I am trying to create a button on my speadsheet and then I
want to link a macro to the button so I can run the macro
by just clicking on the button.

I am using a reference which tells me to create the button
by first clicking on the Control Toolbox toolbar and then
on the Command Button button to draw the rectangle.

My problem is that in the Control Toolbox toolbar is
greyed out in Excel and not available to me.

How can I make the Control Toolbox toolbar available or is
there another way to do this?

Thanks,
Alan
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Control Toolbox toolbar

I figured out my question. Thanks.


-----Original Message-----
Friends,

I am trying to create a button on my speadsheet and then

I
want to link a macro to the button so I can run the macro
by just clicking on the button.

I am using a reference which tells me to create the

button
by first clicking on the Control Toolbox toolbar and then
on the Command Button button to draw the rectangle.

My problem is that in the Control Toolbox toolbar is
greyed out in Excel and not available to me.

How can I make the Control Toolbox toolbar available or

is
there another way to do this?

Thanks,
Alan
.

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
Control Toolbox [email protected] Excel Discussion (Misc queries) 1 August 29th 08 05:58 PM
My Control Toolbox toolbar buttons are (mainly) "greyed out" veryeavy Excel Discussion (Misc queries) 7 November 26th 07 11:48 PM
Control toolbox HISNA Excel Worksheet Functions 0 March 9th 06 05:14 PM
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow Scott Excel Discussion (Misc queries) 1 February 1st 05 01:51 PM
Control toolbox toolbar Bill[_19_] Excel Programming 0 January 13th 04 10:53 PM


All times are GMT +1. The time now is 06:51 PM.

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

About Us

"It's about Microsoft Excel"