Silense
asked on
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?
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.
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.
ASKER
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.
Have you tried modify this key?:
[HKEY_CURRENT_USER\Softwar e\Microsof t\Office\1 4.0\Excel\ Security]
"VBAWarnings"=dword:000000 01
If the key does not exist, create it.
[HKEY_CURRENT_USER\Softwar
"VBAWarnings"=dword:000000
If the key does not exist, create it.
ASKER
Yes I tried before but It didn't work.
ASKER
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.
Could you try from another profile (another user account) on the same computer to see if the problem persist?
ASKER
Still the same. I think somethings need to change in gpedit.msc settings.
User Configuration/Administrati ve Templates/Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/VBA Macro Notification Settings Enabled
After "User Configuration/Administrati ve Templates" I don't see any Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/
How can I find the rest location?
User Configuration/Administrati
After "User Configuration/Administrati
How can I find the rest location?
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/"
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/"
ASKER
After User Configuration/Administrati ve 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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER