+ Reply to Thread
Results 1 to 8 of 8

Making a checkbox "grayed out" when disabled

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Making a checkbox "grayed out" when disabled

    I have a checkbox that is disabled when a formula in G51 results in "No". Is there any way of graying the check box so that it actually looks disabled to the user?

    Please Login or Register  to view this content.
    I tried this code but it just returns the checkbox to empty every time the user clicks it.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Making a checkbox "grayed out" when disabled

    Perhaps you may use an ActiveX checkbox - if you will set its Enabled property to False it will be gray.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Making a checkbox "grayed out" when disabled

    Will the code be the same?

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Making a checkbox "grayed out" when disabled

    No - it will be like:
    Please Login or Register  to view this content.
    if you give same name to ActiveX checkbox.

  5. #5
    Registered User
    Join Date
    11-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Making a checkbox "grayed out" when disabled

    Many thanks, is there a way to change the colour? The gray isn't particularly obvious so would like to make it darker, or even a patterned style?

  6. #6
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Making a checkbox "grayed out" when disabled

    If you refer to actual check mark section, no. Caption is more obvious gray if you have one.

    If there is no caption, Forms control is better with Tristate option. Do you have sample workbook which will show problem you are having with it?

  7. #7
    Registered User
    Join Date
    11-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Making a checkbox "grayed out" when disabled

    Created a quick mockup, basically I want option 3 checkbox to be disabled if option 1 is checked. This is fine in that it prevents the user from checking option 3, but I would like to gray it out to allude to the user that it is not available.
    Attached Files Attached Files

  8. #8
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Making a checkbox "grayed out" when disabled

    You may assign macro to Check Box 1:
    Please Login or Register  to view this content.
    You may also use OptionButtons for options 1 and 3 if only one may be chosen.

+ 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] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  3. Remove "TRUE" "FALSE" words from a linked checkbox
    By MDCK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2008, 03:26 AM
  4. Making the Tools>Options...Calculation "Manua"l Vs "Automatic" a Button.
    By Ecoich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2007, 07:50 PM
  5. "Always trust macros.." checkbox grayed out in Excel
    By ewallig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2006, 04:10 PM

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