Macro Button Colors for Excel 2007

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Macro Button Colors for Excel 2007

  1. #1
    Board Regular lcolson's Avatar
    Join Date
    Dec 2005
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro Button Colors for Excel 2007

     
    How do I edit or change the Macro Button Face color in Excel 2007. I had the capability in Office XP, but I cant find a way with 2007 yet. I can change the Font color, but not the button face color. Can someone help?

    Thanks,
    LC

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    35,599
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

    Quote Originally Posted by lcolson View Post
    How do I edit or change the Macro Button Face color in Excel 2007. I had the capability in Office XP, but I cant find a way with 2007 yet. I can change the Font color, but not the button face color. Can someone help?

    Thanks,
    LC
    Can you explain just what you mean by 'the Macro Button'?
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

  3. #3
    Board Regular lcolson's Avatar
    Join Date
    Dec 2005
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

    I'm referring to the command button to run the macro. I have added it to my worksheet. It is grey. In Excel 2003 I could change the color of the button so it stands out more. With Excel 2007, I am only able to change the color of the font, not the color of the button itself.

    I hope this helps,
    Larry

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    35,599
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

    Quote Originally Posted by lcolson View Post
    I'm referring to the command button to run the macro. I have added it to my worksheet.
    From where? Form Controls? ActiveX Controls? Something else?

    If ActiveX, then can you right click, choose 'Properties' and change the 'BackColor' property?

    If not ActiveX, then what sort of button and how did you change the colour in Excel 2003?
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

  5. #5
    Board Regular lcolson's Avatar
    Join Date
    Dec 2005
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

    FORM CONTROL. I go to the Developer tab, then Insert, but my Active X buttons are not highlighted and I cannot access them for some reason in that worksheet.

  6. #6
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    35,599
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

    You didn't say how you coloured these Form Control Command Buttons in Excel 2003? Or were you using Control ToolBox Command Buttons then?

    In Excel 2007, have a look here:
    Office button|Excel options|Trust Center|Trust Center Settings|ActiveX Settings
    Maybe you have 'Disable all...'?
    Have a look in the built-in Help if you need more info about this.
    Last edited by Peter_SSs; Dec 4th, 2008 at 08:27 AM.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

  7. #7
    Board Regular lcolson's Avatar
    Join Date
    Dec 2005
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro Button Colors for Excel 2007

      
    Thanks Peter, I'll check it out

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com