Solved

Enable Macros Permanently on Excel 2003-2007-2010

Posted on 2011-02-22
4
1,757 Views
Last Modified: 2012-06-27
I want to enable macros permanently in the Excel settings for each of Excel Versions seperately 2003-2007-2010.

Now whenever i open an Macro enabled excel, i have to go manually each time and change the settings.

Instead i want to save the settings permanently, want to know the way it can be done on all the three different Excel versions- 2003,2007,2010
0
Comment
Question by:srikanthv2322
4 Comments
 
LVL 24

Accepted Solution

by:
broomee9 earned 250 total points
ID: 34952251
You would have to change the Security Level to low for each version.  However, this is not recommended.
0
 
LVL 22

Assisted Solution

by:rspahitz
rspahitz earned 250 total points
ID: 34956895
Not sure what you mean by "permanently"...if you change to from, say, High to Medium settings, does it go back to high next time you open?  If so then you may have another Excel session open that resets it.

you should close all sessions, then open 1, change the settings and close it to save the settings "permanently"

However, if you're looking for a way to enable macros without the annoying warnings, Low will work but is not good.  A better way is to create a Digital Signature and use it every time you create/change a macro so that you can have it auto-enable your own code without that warning message.
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 35372858
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

773 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