Saturday, January 21, 2012

How to Change Security Settings in Excel 2010


1. Open Microsoft Excel 2010.
2. Click the 'File' tab menu.
3. Click 'Options' to open the 'Excel Options' window.
4. Click 'Trust Center' on the left side bar.
5. Click the 'Trust Center Settings' button under 'Microsoft Excel Trust Center.'
6. Click 'Add-ins' on the left side bar to disable add-ins or require them to be signed by trusted publisher.
7. Click 'ActiveX Settings' to enable, disable or prompt before enabling ActiveX.
8. Click 'Macro Settings' to enable or disable macros with or without notifications.
9. 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.
10. Click 'File Block Settings' to choose which file types you want to block or file types you want to open in 'Protected View.'
11. Click 'OK' to close and accept all settings.

Blogger news