How to Change Security Settings in Excel 2010


Microsoft Excel 2010 provides security options in its Trust Center Settings. It contains options to enable or disable ActiveX controls, macros and add-ins. You can also choose to block certain file types or open them in protected view. Changing the security settings of Microsoft Excel 2010 can increase or reduce security. The upside of an increased security is you become protected from potentially harmful files. The downside is that some valid files, macros or add-ins may not work, which will affect the overall functionality of Excel.

  • Open Microsoft Excel 2010.

  • Click the "File" tab menu.

  • Click "Options" to open the "Excel Options" window.

  • Click "Trust Center" on the left side bar.

  • Click the "Trust Center Settings" button under "Microsoft Excel Trust Center."

  • Click "Add-ins" on the left side bar to disable add-ins or require them to be signed by trusted publisher.

  • Click "ActiveX Settings" to enable, disable or prompt before enabling ActiveX.

  • Click "Macro Settings" to enable or disable macros with or without notifications.

  • Click "Protected View" to select options to enable when opening potentially dangerous files. With protected view, you can open unknown files in restricted mode, which disables unknown macros, ActiveX controls or add-ins.

  • Click "File Block Settings" to choose which file types you want to block or file types you want to open in "Protected View."

  • Click "OK" to close and accept all settings.


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!