Link to home
Start Free TrialLog in
Avatar of sbsbats
sbsbatsFlag for New Zealand

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?
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sbsbats

ASKER

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)
Avatar of sbsbats

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!!!!!!!!!!!!!!
Avatar of sbsbats

ASKER

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