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?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
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
 
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
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.