+ Reply to Thread
Results 1 to 4 of 4

Toggle Button Colors Dim When Depressed

  1. #1
    Registered User
    Join Date
    06-19-2024
    Location
    Ocala, FL
    MS-Off Ver
    Microsoft 365 v2405
    Posts
    4

    Lightbulb Toggle Button Colors Dim When Depressed

    I have a Toggle Button that locks and unlocks the current sheet for editing. I change the Toggle Button color and text when it locks and unlocks (Locked = Green; Unlocked = Red). For some reason, when I click the toggle button, it changes text and color as expected, but when depressed, the red is a light greyish red, not bright red like the green color is. It's like the Toggle button has some type of grey screen overlay layer over it when depressed. I've searched the Toggle Button's properties and can't find a link to what's causing this color change. Anyone have any ideas what I might check?

    Note: I'm using the RGB(255,0,0) for the red (which should be bright red) and RGB(0,255,0) for the green.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,218

    Re: Toggle Button Colors Dim When Depressed

    The color grays when you click it so you can tell whether it's on or off. That's the nature of a toggle button. It's not typical to use two different colors.

    Since you want to use two different colors, I would suggest you use a Command Button instead, but then you will have to code in the state (have a variable that starts out False, then True when it's clicked, False when it's clicked again, etc.)

    If you need more specific help please attach the file you are working with and indicate the location of the button.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-19-2024
    Location
    Ocala, FL
    MS-Off Ver
    Microsoft 365 v2405
    Posts
    4

    Re: Toggle Button Colors Dim When Depressed

    Thank you for your help. I assumed there would be a way to turn that grey screen off in the toggle button. I can easily convert it to a Command Button.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,218

    Re: Toggle Button Colors Dim When Depressed

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how do i make a toggle button change other toggle buttons value to false
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2018, 04:19 PM
  2. [SOLVED] userform button is depressed and unable to get it to go back to normal.
    By CtrlAltDelete in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2014, 12:17 PM
  3. Toggle Button Does not Toggle OFF when Clicked
    By robbfamily in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2014, 05:12 PM
  4. Toggle multiple font colors
    By simonsco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2014, 12:41 PM
  5. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  6. Click to enter date when toggle button is depressed
    By kevinezra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 12:28 AM
  7. Toggle Calc button - working, but want it showing "depressed"
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2005, 09:05 AM

Tags for this Thread

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