Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 181
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 181
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 181
Default 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?



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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?

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 181
Default 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?

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 181
Default 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?

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
Change color of command button dhstein Excel Discussion (Misc queries) 1 May 21st 09 01:08 AM
how to get my button on a for mto change color Pierre[_2_] Excel Programming 0 November 22nd 05 08:43 PM
change button text color Martin Just Excel Programming 1 November 17th 05 09:15 PM
Change the color of an Excel Macro button? JT Excel Programming 4 November 8th 04 12:21 AM
How do you change button color by moving over it? Preston2002 Excel Programming 1 February 25th 04 06:30 PM


All times are GMT +1. The time now is 07:30 PM.

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"