Thursday, May 27, 2010

Change macro security settings in Excel 2007

Change macro security settings
You can change macro security settings in the Trust Center, unless a system administrator in your organization has changed the default settings to prevent you from changing the settings.
1. On the Developer tab, in the Code group, click Macro Security.
Tip If the Developer tab is not displayed, click the Microsoft Office Button , click Excel Options, and then in the Popular category, under Top options for working with Excel, click Show Developer tab in the Ribbon.
2. In the Macro Settings category, under Macro Settings, click the option that you want.
Note Any changes that you make in the Macro Settings category in Excel apply only to Excel and do not affect any other Microsoft Office program.
Tip You can also access the Trust Center in the Excel Options dialog box. Click the Microsoft Office Button , and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category.