Excel, Visual Basic and security problem.

Posted on 2007-08-02
Last Modified: 2010-04-30

Hello Group,

In part of my code I'm using a procedure to detect number and list of existing macros in an active workbook. That works fine however, I'm having a problem when user has not checked the  "Trust access to Visual Basic Project" in 2nd tab of security tab (Tools > Macros > Security).

Is there any way that I can check it programmatically?

Question by:akohan
    LVL 81

    Accepted Solution

    No, otherwise what would be the point of having a security mechanism?

    I suggest showing a dialog to the user telling them that, in order to use your tool, they need to set that option on.


    Author Comment


    Yes. you are rignt.
    Thanks that's what I did.



    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now