Thursday, May 24, 2012


How to Enable Macros in Microsoft Excel For Income Tax Return (ITR)


 May 24, 2012, 22:36

Income TaxArticlesHOW TO ENABLE MACROS IN MICROSOFT EXCEL FOR RETURN PREPARATION UTILITY

It is necessary to ENABLE the execution of macros in Return-Preparation-Utility in order to enter, validate and generate an .XML file for upload. Follow these steps to ENABLE execution of macros depending on the version of [Microsoft Office Excel] being used to open the Return-Preparation-Utility :
[Microsoft Office Excel 2003]

Navigate through the following excel menu option to reduce the level of security in executing macros :

Tools –> Macros –> Security –> Low

OR

Tools –> Macros –> Security –> Medium

Save the excel-utility and re-open it.

[Microsoft Office Excel 2007]

Navigate through the following excel menu options to reduce the level of security in executing macros :

Excel Options –> Trust Centre –> Trust Centre Settings –> Macro Settings –> Enable all macros

AND

Excel Options –> Trust Centre –> Trust Centre Settings –> ActiveX Settings –> Enable all controls without restriction and without prompting

Save the excel-utility and re-open it.

[Microsoft Office Excel 2010]

When you open the EXCEL-UTILITY, the yellow Message Bar appears with a shield icon and the Enable Content button.
Click on the Enable Content to enable the macros.

Related posts:

1.Download New Saral-II (ITR-1) Excel Based Return Preparation Utility for the F.Y. 2009-10, A.Y. 2010-11
2.Download ITR-5- Online Return Filing Excel Utility for A.Y. 2010-11
3.Download ITR-4- Online Return Filing Excel Utility for A.Y. 2010-11
4.Lets Learn Commands of Microsoft Excel And Microsoft Word
5.Income Tax department released ITR-2 E-filing Return Preparation Software For A.Y. 2010-11

No comments: