ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Button Color (https://www.excelbanter.com/excel-programming/425260-change-button-color.html)

Alberto Ast[_2_]

Change Button Color
 
I created a button assigned to a macro... but it is always gray... how do I
change the color of my buttons?

Michael Arch

Change Button Color
 
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?


Alberto Ast[_2_]

Change Button Color
 
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?


Michael Arch

Change Button Color
 
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?


Alberto Ast[_2_]

Change Button Color
 
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?


Michael Arch

Change Button Color
 
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?


Alberto Ast[_2_]

Change Button Color
 
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?


Alberto Ast[_2_]

Change Button Color
 
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?



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com