• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1237
  • Last Modified:

Macro is locked

HI,

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?
0
sbsbats
Asked:
sbsbats
  • 3
  • 2
1 Solution
 
GrahamSkanCommented:
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.
0
 
sbsbatsAuthor Commented:
Hi,

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)
0
 
sbsbatsAuthor Commented:
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)
Help!!!!!!!!!!!!!!
0
 
sbsbatsAuthor Commented:
cheers
0
 
GrahamSkanCommented:
Sorry I couldn't follow up last night. I went to bed.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now