+ Reply to Thread
Results 1 to 5 of 5

VBA to chane worksheet tab color

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Solon, OH
    MS-Off Ver
    Excel 2010
    Posts
    15

    VBA to chane worksheet tab color

    I have the following code in a Double Click macro. Cells B17 and B18 are marlett checkboxes. I want the tab color to change if either or both cells are checked. If both are not checked I want the tab to be gray.

    The code works to change the color, but the color will not change back when I uncheck the cells.

    Thanks for your help.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: VBA to chane worksheet tab color

    Will this do the trick for you ?

    Please Login or Register  to view this content.
    Harry.

  3. #3
    Registered User
    Join Date
    12-04-2012
    Location
    Solon, OH
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA to chane worksheet tab color

    Same result. The tab changes color, but won't change back.

  4. #4
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: VBA to chane worksheet tab color

    Maybe ?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-04-2012
    Location
    Solon, OH
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA to chane worksheet tab color

    That fixed it, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1