Share via

Change the colour of a macro button

Anonymous
2010-12-29T19:02:21+00:00

Hi All

Tried a quick search could not find an answer...

Can you change the colour / style of a macro button ? If so how ?

Regards

Matthew

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-12-29T19:18:56+00:00

    Hi,

    The button you just right clicked is from the FORMS  toolbox and you can't change the colour of that.

    If you want to change the colour; and get a lot more functionality as well, add a button from theActiveX  toolbox. It's a simple matter to add the new button and cut and paste your code into it.

    To access the ActiveX toolbox

    Developer tab|Controls group|Insert and you will see ActiveX controls.

    If this post answers your question, please mark it as the Answer.

    Mike H

    80+ people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-12T18:55:07+00:00

    So then if I want my button to have any functionality, and I'm on a Mac, I'm forced to reboot into an inferior operating system?

    We want you to use our crappy operating system so we're gonna make our make our software on other platforms intentionally crappy so you'll want to use our crappy operating system. It's the Microsoft way.

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2010-12-29T19:09:02+00:00

    Hi,

    You can change the colour of an ActiveX button by right clicking it and selecting properties.

    If this post answers your question, please mark it as the Answer.

    Mike H

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-05-03T10:06:57+00:00

    Thanks.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2010-12-29T19:14:24+00:00

    Hi Mike,

    Am I missing something, when I right click I get

    Cut Copy Paste

    Exit / edit text

    Grouping

    order

    Assign Macro

    Format control

    The format control is only thing in format control is control of the text not the background.

    Any ideas ?

    Matthew

    0 comments