+ Reply to Thread
Results 1 to 7 of 7

Checkboxes not working

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    Airdrie, AB
    MS-Off Ver
    365
    Posts
    5

    Checkboxes not working

    I have kind of a weird situation here at work. I have an '.xlsm' workbook that has a number of macros built into it. One of the sheets in it has many, many lines. We have check boxes beside each line so that after you check them off and then you can run a macro to hide all non-checked lines. I have had it working on previous machines and when I send the file to others in the office, they are able to use the checkboxes without issue. I have tried the following solutions...all with no luck.

    - save as a new file
    - ensure 'enable content' was selected when opening the file
    - through trust center I have opened everything up so there are no active x and macro restrictions
    - added the file location to the trusted center.

    Just for further information, I can go in to developer mode and make modifications to the checkboxes or other active x controls.

    Hoping someone knows what else I can look at here!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,425

    Re: Checkboxes not working

    The first thing to verify is that the macro is running when it is supposed to. I would add a checkpoint in the macro code to verify this.

    The second thing to check is that the macro is detecting the state of the checkboxes. This can also be done either by checkpoints or debug.print statements.

    Then check to see if it is taking the correct action on checked boxes. Again, checkpoints and debug.print.

    Bottom line is that it seems like you have looked at everything except the code, but the code is where you are going to find the problem.

    I would be happy to take a look if you attach your file (see yellow banner at the top of the page).
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    excel 2016 64bit - Windows 10
    Posts
    1,917

    Re: Checkboxes not working

    Are the links in place - with a copy of the file - delete the checkboxes and try adding again
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-25-2019
    Location
    Airdrie, AB
    MS-Off Ver
    365
    Posts
    5

    Re: Checkboxes not working

    I will have to check and see if it is okay to send the file...proprietary information and all...

    I will say though that I would normally agree that the code is where the problem likely lays except that everyone else that I send the file too doesn't have any issues and everything runs as expected which leads me down the road of a 'machine' or 'permission' issue.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,425

    Re: Checkboxes not working

    Quote Originally Posted by Crawl View Post
    I will have to check and see if it is okay to send the file...proprietary information and all...
    You can delete all the data since the issue is just around the checkboxes.

    I will say though that I would normally agree that the code is where the problem likely lays except that everyone else that I send the file too doesn't have any issues and everything runs as expected which leads me down the road of a 'machine' or 'permission' issue.
    I see your point, though looking at whether the code is even running will give you a clue as to what the root cause might be, and it's easy to check. I am assuming you are using desktop Excel, and not the online version.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,826

    Re: Checkboxes not working

    If they are activex, I would suspect an incompatibility with an office update that has altered the fm20.dll

    Search for and delete any .exd files on your computer (include hidden locations when searching) then try it again.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  7. #7
    Registered User
    Join Date
    07-25-2019
    Location
    Airdrie, AB
    MS-Off Ver
    365
    Posts
    5

    Re: Checkboxes not working

    Thank you all...sometimes you need to go back to the basics. I did an office update and that has solved the issue.

+ 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