Excel Macro Auto Enable

Hi,

How do i enable MS office Excel 2007 and 2010 for Macros automatically.  I don't want to click on security warning which comes with Excel having macro "Macros have been disabled".  

Is there any VBA script or something i put in XLStart folder to automatically enable this?

Thanks
techvtsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cyberkiwiCommented:
0
techvtsAuthor Commented:

Thanks Cyberkiwi,

Yes, that's right. But i want something which can be use as a script or tool so that i don't need to go to Excel options on each PC.
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
In Excel 2010 click File - Excel Options - Trust Center - Macro Settings - Enable all macros.

Then prepare for the situation that some user will download some dud file from the internet that introduces malicious code and you'll spend weeks rebuilding the computer to the original state.

Disabling macro security is a bad idea, but since you've asked for it ...

cheers, teylyn
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Brian PiercePhotographerCommented:
You can't do this with a macro - 'cos the macro won't run unless its enabled - Catch22

Your only options are to:
1. Manually Set Excel to run all macros - you need to do this via macro security on the Developer Ribbon - see pic
2. Sign the macros and manually set excel to run signed macros
xl.jpg
0
Chris BottomleySoftware Quality Lead EngineerCommented:
>>> Is there any VBA script or something i put in XLStart folder to automatically enable this?

Absolutely not the whole idea of the manual selection is to require user intervention to enable macros given as Teylyn states they can be a risk.  Signed macros on teh other hand should be easier to work with

Chris
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
techvts,

this is starting to sound rather like a question on how to bypass macro security settings. Exactly the kind of thing people with malicious intent would ask, to bypass computer security settings.

Macro security is there so the user can decide whether or not to run a macro. Bypassing this through code would mean hacking the user's chance to have a say.

Big NO NO!!
0
Rory ArchibaldCommented:
You would need to use Group Policy or a custom install to do this centrally - see this page for more details (it is, AFAIK, similar to Office 2007):
http://technet.microsoft.com/en-us/library/cc179050(office.14).aspx


Regards,
Rory
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian PiercePhotographerCommented:
There are no Group Policies to control Macro execution - it has to be done manually
0
cyberkiwiCommented:
Hi Rory,

I think you are thinking of the features listed with a value in the column
"Feature status in the 2007 Office system"
as
"Not available in 2007 Office system applications"
0
techvtsAuthor Commented:
Hi Guys,

Thank you for prompt replies.  Yes, i'm aware of risk involved but it's for internal lab use. Many times we have to format and reinstall Office so need an automated solution as i don't need to click on warning each time i open macro based worksheet.

Thanks again.
0
cyberkiwiCommented:
This page is a great reference:

HKEY_CURRENT_USER/Software/Policies/Microsoft/Office/12.0/Excel/Security

You should be able to set up a registry file using OCT entries for volume licensed use.
Or group policy keys.
0
Rory ArchibaldCommented:
@cyberkiwi:
"I think you are thinking of the features listed with a value in the column
"Feature status in the 2007 Office system"
as
"Not available in 2007 Office system applications"


I'm not really sure what you mean by that?


@KCTS:
As far as I know, you can set the VBASecurity reg key using Group Policy - is this not the case?


Regards,
Rory
0
Brian PiercePhotographerCommented:
I am not aware of any dedicated group policy for VBA security (If there is I would like to know where it is)
0
Rory ArchibaldCommented:
If you download the 2007 Admin templates from Microsoft, you can set macro security in there.
0
Brian PiercePhotographerCommented:
There is a policy to supress the warnings - I understoood that was all it did (ie just prevented the message on the screen). Does this actually allow the macros to run without warning ?
0
Rory ArchibaldCommented:
One of the options is "No security checks for macros (not recommended)" which in my tests sets the Trust Center to enable all macros (and prevents you from changing it).
0
Brian PiercePhotographerCommented:
That interesting - you (or should I say I) learn something everyday - where is this setting I don'r see it on my list (I'm probably looking in the wrong place)
XLADMX.jpg
0
Rory ArchibaldCommented:
VBA Macro Warning settings (last entry)
0
techvtsAuthor Commented:
Thank you guys,  i will check what works and update you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.