How to enable macros in Excel

How to enable macros in Excel 2003?

To enable macros in Excel 2003, please follow the steps below:

1. On the Tools menu, point to Macro, and then click Security. 2. On the Security Level tab, select Low.

3. Close & Re-open Nirmal XBRL Generator.xls in MS-Excel.

How to enable macros in Excel 2007 ?

To enable macros in Excel 2007, please follow the steps below:

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.

If the Developer tab is not displayed, click the Microsoft Office Button   (2007), 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.

3. Close & Re-open Nirmal XBRL Generator.xlsm.

  

How to enable macros in Excel 2010?

1. Click on the ‘File’ tab and then on ‘Options’ tab.

2. In “Outlook Options” window, select the ‘Trust Center’ tab and then click on the ‘Trust Center Settings’ tab.

3. Now in the “Trust Center Settings” window, click on the ‘Macro Settings’ tab and then under the ‘Macro Settings’ group, select the check box that says “Enable all Macros”.

4. Close & Re-open Nirmal XBRL Generator.xlsm.

How To Change Regional Settings of Date in Windows?

To open the Regional and Language Options tool:

1. Click Start, and then click Control Panel.

2. Click Date, Time, Language, and Regional Options, and then click Regional and Language Options.

3. To change one or more of the individual settings, click Customize.

NOTE: The location selection that you make includes default display options for the way dates, times, and numbers are displayed.

To Change the Date Display

1. In the Customize Regional Options dialog box, click the Date tab to specify any changes you want to make to the short date and the long date.

2. Set SHORT DATE FORMAT to dd-MM-YYYY.