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.
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.
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
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
Follow these steps to view and set the macro security level in Excel 2007:
- 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.- 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.
- Click OK.
Bookmarks