asked on

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

cyberkiwi

Have a look at
http://office.microsoft.com/en-us/excel/hp100969191033.aspx

techvts

ASKER

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.

SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Brian Pierce

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Chris Bottomley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brian Pierce

There are no Group Policies to control Macro execution - it has to be done manually

cyberkiwi

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"

techvts

ASKER

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.

SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rory Archibald

@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

Brian Pierce

I am not aware of any dedicated group policy for VBA security (If there is I would like to know where it is)

Rory Archibald

If you download the 2007 Admin templates from Microsoft, you can set macro security in there.

Brian Pierce

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 ?

Rory Archibald

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

Brian Pierce

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

Rory Archibald

VBA Macro Warning settings (last entry)

techvts

ASKER

Thank you guys, i will check what works and update you.