Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a button assigned to a macro... but it is always gray... how do I
change the color of my buttons? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rather than using the button from the Forms Menu, select the button from the
Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Michael,
Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Two things,
1.- there are more colors on the Palette tab 2.- From the Main Menu Select - View -ToolBars-Control Tool Box This will bring the Control Tool Box Bar into view, click on the Square/Ruler/Pencil Icon and that will bring you into editing mode, so you can select the properties of your button again. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: Michael, Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was able to go back to my menu but could not find the Palette tab with the
extra colors... maybe is what I already have with grays and blues but I was looking for greens.. are those available? Thanks again for your prompt respose. "Michael Arch" wrote: Two things, 1.- there are more colors on the Palette tab 2.- From the Main Menu Select - View -ToolBars-Control Tool Box This will bring the Control Tool Box Bar into view, click on the Square/Ruler/Pencil Icon and that will bring you into editing mode, so you can select the properties of your button again. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: Michael, Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When you access the properties window for your button and click on the
dropdown box, a two tab mini window shows( One reads System, the other reads Palette) in there you will find the Green and yellow, red, pink, purple, etc. colors. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I was able to go back to my menu but could not find the Palette tab with the extra colors... maybe is what I already have with grays and blues but I was looking for greens.. are those available? Thanks again for your prompt respose. "Michael Arch" wrote: Two things, 1.- there are more colors on the Palette tab 2.- From the Main Menu Select - View -ToolBars-Control Tool Box This will bring the Control Tool Box Bar into view, click on the Square/Ruler/Pencil Icon and that will bring you into editing mode, so you can select the properties of your button again. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: Michael, Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I founf the pallete tab... thanks
"Michael Arch" wrote: Two things, 1.- there are more colors on the Palette tab 2.- From the Main Menu Select - View -ToolBars-Control Tool Box This will bring the Control Tool Box Bar into view, click on the Square/Ruler/Pencil Icon and that will bring you into editing mode, so you can select the properties of your button again. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: Michael, Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Now I got it the way I expected just have one new problem.... I can not make
the button to work unless I hit my previous macro button... if I do not do so and hit the new Control Tool Box button it will not work... looks like it stays in edit mode... how do I make it to work without executing another macro...? I want to delete my old gray macro. "Michael Arch" wrote: When you access the properties window for your button and click on the dropdown box, a two tab mini window shows( One reads System, the other reads Palette) in there you will find the Green and yellow, red, pink, purple, etc. colors. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I was able to go back to my menu but could not find the Palette tab with the extra colors... maybe is what I already have with grays and blues but I was looking for greens.. are those available? Thanks again for your prompt respose. "Michael Arch" wrote: Two things, 1.- there are more colors on the Palette tab 2.- From the Main Menu Select - View -ToolBars-Control Tool Box This will bring the Control Tool Box Bar into view, click on the Square/Ruler/Pencil Icon and that will bring you into editing mode, so you can select the properties of your button again. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: Michael, Thanks for your quick response... Even the colors are limited it worked as requested... I was looking into some corporate colors which were not available the way to told me... but I have a nother problem... it worked fine the first time but then I wanted to go back and click right buttom but now the menu does not come un to the screen any more... Not sure if it is because I added my macro to the view code screen.. any idea what can be happening...? how do I go back to edit the buttom parameters? "Michael Arch" wrote: Rather than using the button from the Forms Menu, select the button from the Control Tool Box Menu, right click on it and select properties in the properties windows change the Back color to the one you prefer. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Alberto Ast" wrote: I created a button assigned to a macro... but it is always gray... how do I change the color of my buttons? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change color of command button | Excel Discussion (Misc queries) | |||
how to get my button on a for mto change color | Excel Programming | |||
change button text color | Excel Programming | |||
Change the color of an Excel Macro button? | Excel Programming | |||
How do you change button color by moving over it? | Excel Programming |