Solved

Excel 2007 enabling macros

Posted on 2014-02-06
4
431 Views
Last Modified: 2014-02-17
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
Comment
Question by:jegajothy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 333 total points
ID: 39840319
0
 
LVL 3

Assisted Solution

by:DEVLitehouse
DEVLitehouse earned 167 total points
ID: 39840329
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
 
LVL 27

Assisted Solution

by:MacroShadow
MacroShadow earned 333 total points
ID: 39840483
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
 

Author Closing Comment

by:jegajothy
ID: 39864752
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question