Macro is locked

Posted on 2011-10-05
Last Modified: 2012-05-12

New to Office 2010 - I created a macro and a custom button that I added to the ribbon - it all worked fine - now when I go into my VBA editor I can't acces any of my macros - I get a dialog box that says "Project Locked", "Project is unviewable" - these are stored in my startup folder - whats going on here? security setting?
Question by:sbsbats
    LVL 76

    Accepted Solution

    You cannot edit macros whose template is only visible in the VBA editor because the template is in the startup folder.

    You will have to open the template as a document if you want to view and edit the VBA code in it.

    Author Comment


    I just want to run the macro - I created a .dotm template that contains a simple macro - assigned this to a quick access button - when I now click this button I get this error - "the macro cannot be found or is disabled because of your security settings.
    When I click on view-macros none are available.
    Shouldn't I be able to create - save in startup - and run the macro anytine (as its loaded from the startup folder)

    Author Comment

    The macro (saved as a .dotm) is loaded as an Add-in - I can see that ticked but when I try and run I get the above error message - 2 options are security settings (I have set to enable all macros) and add-ins (as mentioned it loads)

    Author Closing Comment

    LVL 76

    Expert Comment

    Sorry I couldn't follow up last night. I went to bed.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now