Give me details about security options in Excel?

Macro security settings and their effects The following list summarizes the various macro security settings. Under all settings, if antivirus software that works with 2007 Microsoft Office system is installed and the workbook contains macros, the workbook is scanned for known viruses before it is opened. Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents that contain unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system. Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis. Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification. Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. Using this setting makes your computer vulnerable to potentially malicious code and is not recommended. Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box. read less

In Excel, one can change the macro security settings to control where one is running macros. Following are some levels of security : 1. Disable all notification the highest lvl of security which will prevent running macros in ur system 2.disable all with notification is the medium lvl security which gives u the notification to open/execute/enable macro files or not. 3.disable all except digitally signed - only digitally signed files will be executed. 4. one may Enable macros - and can execute all macros files with out user intervention read less

You have CELL (lock cells for restricting edits and hide formula) security; SHEET protection to prevent format cells/insert rows or columns/delete rows or columns/hide and unhide rows/columns etc. WORKBOOK Structure protection to prevent Sheet delete/Insert.move or copy; WORKBOOK Windows protection to prevent from closing/minimizing/restoring the workbook window; WORKBOOK encrypt password option to protect entire workbook with OPEN or MODIFY password. read less

1. Disable all notification the highest level of security which will prevent running macros in ur system 2.disable all with notification is the medium lvl security which gives u the notification to open/execute/enable macro files or not. 3.disable all except digitally signed - only digitally signed files will be executed. 4. one may Enable macros - and can execute all macros files with out user intervention. read less