Excel 2007 enabling macros

My OS is win 7 prof 64 bit and I use Excel 2007 where I have created a macro.  But when I try to run it I get the error that "the macros in this project are disabled.  please refer to the online help or documentation of the host application to determinw how to enable macros.
I had enabled the macros by going to Excel Options  and then to the Trust Centre, and clicking somewhere Enable Macros.  But I still get this error.
Please advise me how to overcome this error.  possibly I am doing the setting in he wrong place.  Thank u.
jegajothyretiredAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DEVLitehouseConnect With a Mentor Commented:
This Knowledge Base article discusses your exact error, and how to fix it quickly. It looks like you have the security setting set too high.

https://support.microsoft.com/kb/215715
0
 
MacroShadowConnect With a Mentor Commented:
Security setting set too high is not a problem, it is designed to protect you. All you have to do is add your file/location to the safe list. That's what you will read about in my article.
0
 
jegajothyretiredAuthor Commented:
thank u.
0
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.

All Courses

From novice to tech pro — start learning today.