Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

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.
0
jegajothy
Asked:
jegajothy
  • 2
3 Solutions
 
DEVLitehouseCommented:
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
 
MacroShadowCommented:
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
 
jegajothyAuthor Commented:
thank u.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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