Set the Macro Security Level in Excel 2007

[NIcaBoy]

Hello,
I need to open an Excel file that contains macros. Excel 2007 does not activate them or not. As a result, the file is not working as it should. Could you tell me what menu I can find access to the macro security level ?

Thank you in advance.

[ThoMas321]

I found the solution. I you do share this in case anyone interested.

Case 1: when opening the file, Excel displays a message over 1res cells: "Security Warning: The content asset has been disabled." with the Options button. Click on it and check the "Enable this content.

Case 2: The above message does not appear.

• Click on the bubble Office (top left)
• Click on Excel Options (bottom right of the drop-down list)
• In the Management Center of confidentiality, click the Settings Management Center of confidentiality ...
• Parameter macros, select the option you want as appropriate. In mine it is Enable all macros.

I hope this helps someone

[Glenny]

In Microsoft Office Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.

For more information see here http://office.microsoft.com/en-us/ex...969191033.aspx

[Eric B]

Follow these steps to view and set the macro security level in Excel 2007:

1. On the Developer tab, click the Macro Security button in the Code group.
   
   The Trust Center dialog box appears with the Macro Settings tab selected.
   
2. Set a security level:
   
   • Disable all macros without notification: Allows you to run only those macros stored in a trusted location. Click the Trusted Locations setting in the left pane to manage these trusted locations. Also, since the macros are automatically disabled, this option disables security alerts.
     
   • Disable all macros with notification: Displays a security alert when a workbook with macros opens. You can then decide whether to enable the macros associated with the workbook. This is the Excel default setting.
   • Disable all macros except digitally signed macros: You can run only those macros that are digitally signed.
     
   • Enable all macros: Allows macros to run without a notification. This can be helpful if you run a lot of macros, but be aware of the risk when using macros from unknown sources.
   
   
3. Click OK.