Link to home
Start Free TrialLog in
Avatar of WiseOwl Excel
WiseOwl ExcelFlag for Pakistan

asked on

Problem VBA Security Disable After Restart or Relogin Windows.

I Have Problem with Microsoft Office 2010 Excel i have Enable Security Settings but when i restart computer it automatically disabled

i want macro security options enabled for any time and through some regitory or  hotkey or any other solution.

Please Guide Regards,
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

How are you changing settings? This explains the correct way to do it, With what's happening I would say it hasn't been set up correctly.

Change macro security settings in Excel
Avatar of WiseOwl Excel

ASKER

I am Changing Macro Security Level by Going Developer Tab and Security Option.
Also
I am Changing Macro Security by Going Options > Trust Center > Trust Center Settings > Macro Settings > Enable All Macros.

but with both way when i restart computer it disabled.

Please Guide Solution.

Regards,
Enable all macros is not a good idea, it may allow malicious macros to run, you need to use Disable all macros with notification.

Whichever option though should not reset.

This might help

Plan and configure Trusted Locations settings for Office 2013
Is it your personal or Professional computer ?

In the case of Professional, GPOs (AKA Sys admin rules) might be in the work. In that case, Nothing you can do.
Its My Personal Computer Not Network of Office Computer...!!!

Please Consider my problem when i restart it auto disable.

Regards,
Does this occur with other Office programs like Word?

Have you tried Trusted Locations

I've found this Registry setting but have not tested it

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security]
"VBAWarnings"=dword:00000001
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.