Macro Settings are grayed out

I can't change the Macro Settings as it all grayed out. Please let me know how remove that settings from registry?
SilenseAsked:
Who is Participating?
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.

SilenseAuthor Commented:
Please let me know how to disable this option in Excel 2010. At the moment I can't change anything becuase it all grayed out!
0
luconstaCommented:
Hi,

If this happens on a company computer, it may be a group policy applied by your network administrator and  you should address this problem with him.

If the problem is on a personal computer the installation of your Office it may be corrputed. In this case I would recommend reinstall it either by running the setup and selecting the repair option or even better by removing completely and reinstall it again.
0
SilenseAuthor Commented:
Last time I resolve this issue by changing the settings in regsitry or somewhere but now I can't remember it. I found few referance but to add DWARD value but it seems not working. Also I found to change local group policy which makes "Macro Settings" disabled. I tried both ways but it not seems working.
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.

luconstaCommented:
Have you tried modify this key?:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]
"VBAWarnings"=dword:00000001

If the key does not exist, create it.
0
SilenseAuthor Commented:
Yes I tried before but It didn't work.
0
SilenseAuthor Commented:
I create this DWAORD value & close the regedit. Then open the Excel still all "Macro Settings" are grayed out. Please let me know if I need to do anything else.
0
luconstaCommented:
Could you try from another profile (another user account) on the same computer to see if the problem persist?
0
SilenseAuthor Commented:
Still the same. I think somethings need to change in gpedit.msc settings.

User Configuration/Administrative Templates/Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/VBA Macro Notification Settings Enabled

After "User Configuration/Administrative Templates" I don't see any Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/

How can I find the rest location?
0
luconstaCommented:
You don't see that branch because you have to download Office 2010 Administrative Template files and then in the Group Policy console right click on the Administrative Templates and import the corresponding "excel14.adm" file from the ADM\en-us folder resulted from unpacking the downloaded file.

See after tv\weaking the VBA Macro Notification Settings" but be aware the option is in the "Trust Center" branch not "Trust Center/Trusted Locations/"
0
SilenseAuthor Commented:
After User Configuration/Administrative Templates I found "Classic Administrative Templates " and then all the way upto /Microsoft Excel 2010/Excel Options/Security/Trust Center/VBA Macro Notification Settings and make it "Enabled" to VBA Macro Notification Settings then open the excel still it's all grayed out.
0
SilenseAuthor Commented:
Haven't said that before "VBA Macro Notification Settings" was "Not Configured". I make it enabled but still all macro settings are grayed out in excel.
0
luconstaCommented:
You did not say anything about reinstalling as suggested in my previous comment: ID: 39482289 - it may solve the problem...
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
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 Office

From novice to tech pro — start learning today.