none
Addin only disconnected by administrator RRS feed

  • Question

  • Excel VBA

    This code works for me

    Application.COMAddIns(icount).Connect = False

    But users get the error message.

    "this addin is installed for all users on this computer and can only be connected or disconnected by an administrator"

    Wednesday, March 15, 2017 9:39 PM

All replies

  • Hi Mike Gowing,

    I find that this error is occurs due to insufficient permission of user.

    there is no issue with the code.

    so you need the permission for user that allows user to perform this operation.

    so you need to contact to the administrator for the permission.

    in other words , we can solve this issue by disabling the UAC.

    Reference:

    Disable User Account Control (UAC) the Easy Way on Win 7, 8, or 10

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, March 16, 2017 2:55 AM
    Moderator
  • Mike,

    Try to run your application with admin privileges (Run as Administrator). The fact is that machine-level add-ins are registered to the HTML hive in the windows registry which requires admin privileges. See Registry Entries for Application-Level Add-Ins for more information.


    profile for Eugene Astafiev at Stack Overflow, Q&A for professional and enthusiast programmers

    Thursday, March 16, 2017 11:19 AM