sbsbats
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!!!!!!!!!!!!!!
Help!!!!!!!!!!!!!!
ASKER
cheers
Sorry I couldn't follow up last night. I went to bed.
ASKER
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)