Consulting

Results 1 to 13 of 13

Thread: Listview on my Windows 11 with Excel 365

  1. #1
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location

    Listview on my Windows 11 with Excel 365

    On my Win 11 64bit tablet I am getting this error:

    "the subject is not trusted for the specified action"


    when I try to add a listview I get this error. If I create a test file with the listview, it disappear from the form. I searched with Google to try to find out how to fix this but not going anywhere with it. Hopefully, someone can help me solve this.

    thanks

  2. #2
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location
    well, let me add TreeView has the same problem...... I don't know if it is the MSCOMCTL.OCX problem? I copied the OCX file from my working machine and put it onto the Win 11 machine still same problem! I unregistered and re-register with my new ocx file, still not working.

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,465
    Location
    This is all that I could find.

    Primary Causes:


    1. Missing or Corrupt Common Controls Library (MSCOMCTL.OCX): The ListView control is part of the Microsoft Common Controls library. If this file is missing, unregistered, or corrupted, Windows won't trust it. This is the most frequent culprit.
    2. Incorrect Bitness (32-bit vs. 64-bit): While your Windows 11 is 64-bit, Excel 365 can be either 32-bit or 64-bit. If you're trying to use a 32-bit ListView control with a 64-bit version of Excel (or vice-versa), you'll encounter trust issues. It's crucial that the bitness of the control matches the bitness of the Excel application.
    3. Security Settings/Trust Center: Excel's Trust Center settings might be preventing the control from running. This could be due to macros being disabled, untrusted locations, or specific ActiveX settings.

    Since you have copied the mscomctl.ocx from one computer to another, are you sure it is the correct bit (32 vs 64)?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location
    Thanks Aussie, you jogged my poor memory…. I am running 64bit office.
    I then did more digging and I found the 64 bit version of mscomctl.ocx but the file won’t register….
    I think I am stuck! Anyone have more insight?

  5. #5
    i don't see any problem on my a2021 x64.
    lv1.jpglv2.jpglv3.jpglv4.jpg

  6. #6
    Microsoft has changed the defaul security setting for activeX controls in Trust center. Change the setting to match this one to get the treeview working again.
    2025-06-23_10-32-33.jpg
    Please note that this is now the default setting for Office, so you might consider alternatives like my free all-VBA treeview: https://jkp-ads.com/articles/treeview.aspx
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  7. #7
    I have same setting on my Exel, but like I said, I don't get any error message when using Treeview or Listview.

  8. #8
    Change the setting to the top one (the new default). That will trigger the message.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  9. #9
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location
    Quote Originally Posted by Jan Karel Pieterse View Post
    Microsoft has changed the defaul security setting for activeX controls in Trust center. Change the setting to match this one to get the treeview working again.
    2025-06-23_10-32-33.jpg

    Thanks, Jan. Really appreciate the help and fixed my problem

    As to your Treeview, I used it in the past and it is great! But for my little project, I need Listview.

  10. #10
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location
    Quote Originally Posted by arnelgp View Post
    I have same setting on my Exel, but like I said, I don't get any error message when using Treeview or Listview.
    Thanks for the help, arnelgp!

  11. #11
    We also have a ListGrid control, but it isn't free I'm afraid: https://jkp-ads.com/articles/treeview.aspx#ProVersion
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  12. #12
    VBAX Expert
    Joined
    Aug 2004
    Posts
    818
    Location
    Jan:
    Thanks for pointing out different controls that you are offering, however, this is a small project for my son. I don't need anything heavy duty.

  13. #13
    You're welcome! Good luck with that project.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

Posting Permissions

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