Results 1 to 4 of 4

Commandbutton backcolor

This is a discussion on Commandbutton backcolor within the Excel Questions forums, part of the Question Forums category; I successfully have used the following code to set the back color (44 Orange) of command buttons Code: Sheets("Main").CommandButton1.BackColor = ...

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    South Bend, IN
    Posts
    991

    Default Commandbutton backcolor

    I successfully have used the following code to set the back color (44 Orange) of command buttons

    Code:
    Sheets("Main").CommandButton1.BackColor = RGB(255, 204, 0)
    At least until today, it now fails on my computer and on the user computer!

    The command button exists BUT displays the run-time error 438 message:

    "Object doesn't not support this property or method"

    Thanks in advance
    Excel 2003 and 2010 on 64bit Windows-7

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    27,519

    Default Re: Commandbutton backcolor

    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    South Bend, IN
    Posts
    991

    Default Re: Commandbutton backcolor

    Fascinating, it solved it

    BUT

    The files had a 2012 date associated with them....
    As in "why did it start just today"???
    Excel 2003 and 2010 on 64bit Windows-7

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    29,370

    Default Re: Commandbutton backcolor

    There's a conflict between the information in those .exd files and the files that Tuesday's Office patches updated.

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