![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: May 2002
Location: Tennessee, USA
Posts: 72
|
I've created several buttons that I've assigned macros to. So far I've just revised the text to describe the button and made the text different colors. Is there a way to make the buttons themselves different colors. (I've used the Forms toolbar to create the buttons.) Thanks.
|
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Apr 2002
Location: Sarasota, FL
Posts: 1,539
|
right click on butto,
properties, back color, pallete, there you go! Corticus |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Its worth pointing out I believe this will not work with command buttons non user form specific,
The fix it to create a drawing box and colour assign the script to that box, which in effect becomes the command button.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
|
#4 |
|
Board Regular
Join Date: May 2002
Location: Tennessee, USA
Posts: 72
|
Corticus,
Can't do this with a button created using the Forms toolbar. So....I'll use the Controls Toolbox the next time I need buttons of different colors. Thanks. |
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Apr 2002
Location: Sarasota, FL
Posts: 1,539
|
Thanks for the info!
Corticus |
|
|
|
|
|
#6 |
|
Board Regular
Join Date: May 2002
Location: Tennessee, USA
Posts: 72
|
Right, Jack in the UK. The other option seems to be to create, say, a text box with the colors you want and just assign your macro to that box. (Of course, you could add a shadow to make it look more like a button.)
Thanks all. |
|
|
|
|
|
#7 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Yes that’s correct, you have entered the merky deep world of Jack, I just have a hate of standard, why have a boring button when I can have a picture of the English world cup squad! Does the very same thing and looks super cool (if your English that is)
Mark Celtic will never make the world cup! Doubt they could polish it! He he! I use anything to command, just some fun, even the BOSS wil go eh! Say how’s that. I worked on animated gif in excel of a British flag and script attach it, I failed.. but a very good pal did solve the movement issues Little grey buttons – not for me.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
|
#8 |
|
Board Regular
Join Date: Feb 2002
Location: Dog Beach, Florida. Yeaahh!
Posts: 4,038
|
But how does one assign a macro to a button created in the Control Toolbox?
__________________
Barry- Photo Restoration/Enhancement http://www.smiledogproductions.com click below for detour
|
|
|
|
|
|
#9 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
The set same way right click it and assign the macro.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
|
#10 |
|
Board Regular
Join Date: Feb 2002
Location: Dog Beach, Florida. Yeaahh!
Posts: 4,038
|
Jack, when I right-click on a button I created with the Control Toolbox, there is no option to "Assign Macro"?
__________________
Barry- Photo Restoration/Enhancement http://www.smiledogproductions.com click below for detour
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|