+ 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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    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).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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

  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)

Similar Threads

  1. Move and Size Checkboxes VBA not working
    By sklee1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2019, 02:23 PM
  2. [SOLVED] Save as PDF with working checkboxes
    By SoothSailor in forum Excel General
    Replies: 1
    Last Post: 10-10-2014, 12:01 PM
  3. Active X Checkboxes not working on Mac
    By lmbshaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 04:18 PM
  4. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  5. Macro with checkboxes - not working
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 06:23 AM
  6. Replies: 8
    Last Post: 08-22-2012, 03:22 PM
  7. [SOLVED] Quick Start to working with checkboxes etc within a worksheet
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-15-2005, 08:05 AM

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