Monday, July 23, 2012

How To Enable Macro in EXCEL while using Income Tax Return e-Filing Utility


Friends,

The Last to file your Income Tax Return for the Financial Year 2011-12 (Assessment Year 2012-13) is very close i.e. 31st of July 2012. The salaried persons who have a total Income above Rs. 10 Lac have been made compulsory to file their Return in electronic mode .The Income tax Department has provided Return Preparing Software (RPU's) free of cost to prepare your Income Tax Return and prepare .XML file to upload the same after Login from www.incometaxindiaefiling.gov.in with your credentials. While preparing data in Excel file there are some precautions to be taken without which you will not be able to prepare your .XML file to upload.  When the macro security level in Excel is set to Low (not recommended), macros can be run without prompting. When macro security is set to Medium, Excel displays a dialog box asking if you want to enable macros. When macro security is set to High (the recommended macro security setting for all users), Excel allows you to run only those macros that are digitally signed.

MS OFFICE 2003
  • To allow unsigned macros to run, the Trust all installed add-ins and templates check box must be selected on the Trusted Publishers tab of the Security dialog box. This option is selected by default. If it is not selected (recommended), Excel allows you to run only macros that have trusted digital signatures. 
  • On the Tools menu, point to Macro, and then click Security. 
  • On the Trusted Publishers tab, select the Trust all installed add-ins and templates check box.
MICROSOFT OFFICE EXCEL 2007 AND 2010 
  1. Click the Microsoft Office Button , and then click Excel Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Click the options that you want:
  • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system. 
  • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis. 
  • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification. 
  • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended. 
  • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and pro grammatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model pro grammatically, the user running the code must explicitly grant access. To turn on access, select the check box. 
-->

Blogger news

Thanks for Your Visit

style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8636229337784449"
data-ad-slot="2782765492">

Labels

2012-13 (1) 80C (33) 80E (22) 80GG (8) Aadhaar (21) Accountant (70) admiss (1) Admission (48) Admit Card (10) AICL (3) AICTE (4) AIEEE 2012 (6) Allahabad Bank (3) Andhra Bank (3) Anna Hazare (11) APDSC (3) APSPSC (4) ASI (3) Asia Cup 2012 (2) Assistant (212) Assistant Manager (106) Auditor (3) Axis Bank (4) B.Ed (23) Bank of India (6) Bank of Maharashtra (10) BARC (6) BHEL (66) BMB (1) BOB (13) BOI (6) BPCL (30) BPO (1) BSEB (1) BSF (16) BSNL (13) Canara Bank (11) Capital Gain (2) Career (246) CBSE (16) CCS HAU (3) CDAC (2) Central Bank of India (10) Central Excise (36) Challan Status (7) Champions League (11) CHB (3) CHSL (5) Clerical (128) Company (8) Conductor (2) Corona (1) Corono (1) Covid-19 (2) Cricket (3) CRPF (5) CSIR (3) CTET (21) CUHP (2) Customs (23) CWE (29) Data Entry Operators (26) Date Sheet (2) dbtl (1) DDA (7) Dearness Allowance (5) Delhi Metro (32) Delhi Police (51) Delhi University (50) Dena Bank (1) Digital Signature (7) DJB (2) DLF IPL (13) DMRC (13) Driver (1) DSSSB (3) e-Filing (69) e-Payment (27) e-TDS (61) Engineers (230) EPFO (8) FaceBook (3) FCI (4) Food Civil Supply (8) Foreign Trade (1) Forms (14) Formula One Race (3) Free Internet (8) Freshers (4) GAIL India (62) GATE (10) GET (1) GGB (1) GIC (2) GNDU (2) Government (6) GPRS (2) HAL (5) Happy Diwali (2) HCL (3) HECL (1) High Court (13) HOLI (2) HPCL (33) HPEG (1) HPPSC (27) HPSEB (7) HPSSB (9) HRA Rebate (6) HSSC (23) HTET (16) HUDA (4) IBPS (62) ICC World Cup 2015 (10) ICICI (3) IDBI (1) iim (3) IIST (1) IIT-JEE (12) IIT-Ropar (1) Importer Exporter Code (3) Income Tax (314) Indian Air Force (25) Indian Army (33) Indian Bank (10) Indian Navy (25) Indian Railways (18) INFOSYS (11) Inspector (37) Intel (1) Intelligence Bureau (10) IOB (5) IOCL (40) IPL T20 (28) ISAT (3) ISRO (7) ITI (3) JPSC (2) Junior Engineer (195) Jurisdiction (1) Kendriya Vidyalaya (2) Knowledge (1) KPCL (5) KUK (9) KVS (3) LAW (1) Lecturer (1) LIC (11) Lok Sabha (3) Lokpal Bill (9) LPG (3) Lum-Sum Savings (4) M.Ed (5) Madhya Pradesh (1) Manager (105) MBA (6) MCD (4) MDU (22) Medical Reimbursement (3) Mewar (1) MICR (2) Misc (20) Mobile (2) MP High Court (8) MPPEB (3) MSOFFICE (10) MTNL (2) NBCC (13) NDA (2) NDMC (2) NET (1) NIT (1) Nokia (1) Non-Teaching (40) NPCIL (6) NPS (1) NRDC (1) NRI's (1) NSDL (5) NTPC (9) OBC (13) Officer's (165) ONGC (12) OPGC (1) OPGCL (1) Oriental Insurance (5) OROP (1) PAN (11) Patwari (3) PFC (1) PGB (1) PGI Rohtak (7) PGIMER (6) PGT (12) PNB (18) Post Office (13) Power Grid (24) PPF (7) Probationary Officer (66) PTU (3) Punjab and Sind Bank (12) Railway Budget (17) Rajasthan Police (13) Rajya Sabha (1) RBI (23) REC (1) Refund (2) Register Your Company in 24 HRS (8) Result (64) RGU (2) RITES (10) RPSC (5) RRB (20) Sahaj (2) SAIL (51) SBI (41) SBOP (6) Scholarship (5) SDE (5) Service Tax (16) Service Tax Rate 12.36 (2) Shortcut (2) Sikkim University (3) SMS (1) Sole Proprietorship Business (1) Solved Test Papers (5) Specialist Officer (39) SSC (34) st-3 (1) Staff Nurse (4) STAT test (10) Sugam (1) Supreme Court of India (6) Syndicate Bank (2) T20 (14) Tally (13) TAN (2) TCS (3) Teaching (38) Technical (189) Term Deposit Interest (37) TGT (11) Ticket Booking (3) TIN (2) TMC (1) TRACES (3) Trainee (31) Tution Fee (3) Twenty20 (4) Typist (1) UCO Bank (4) UDC (2) UGC (4) UID (7) Union Bank of India (7) Union Budget (6) United Bank (4) UPCL (3) UPPSC (27) UPSC (38) UTI (4) Vijaya Bank (3) VIZAG (3) WBSEDCL (1) Wipro (3) WORD DOCUMENT (5) Yahoo (1)

Infolinks