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?
sbsbatsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
GrahamSkanRetiredCommented:
Sorry I couldn't follow up last night. I went to bed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.