TDS || Excel export issue → MACRO Enabled Process

Unblock a single file →

In most cases, you can unblock macros by modifying the properties of the file as follows:

1. Open Windows File Explorer and navigate to the folder "C:\Program Files (x86)\K.D.K. Software\Spectrum\Zen TDS\e-TDStcsfvu".
   
2. Right-click on the file named TRACES-Justification.xls and select Properties from the context menu.
   

      

1. Within the Properties dialog, go to the General tab.
   
2. At the bottom of the General tab, you'll find the option to Unblock the file. Check the box next to Unblock.
   

      

1. Click Apply and then OK to save the changes.
   

How to enable macros for individual workbooks →

There are two ways to turn on macros for a certain file: directly from the workbook and through the Backstage view. Enable macros via security warning bar

With the default macro settings, when you first open a workbook containing macros, the yellow security warning bar appears at the top of the sheet right under the ribbon:

      

      

      

If the Visual Basic Editor is open at the time, you are opening the file with macros, the Microsoft Excel Security Notice will be displayed:

      

If you trust the source of the file and know that all the macros are secure, click the Enable Content or Enable Macros button. This will turn on the macros and make the file a trusted document. The next time you open the workbook, the security warning won't appear.

If the source of the file is unknown and you don't want to enable macros, you can click the 'X' button to close the security warning. The warning will disappear, but macros will remain disabled. Any attempt to run a macro will result in the following message.

      

If you've disabled macros accidentally, simply re-open the workbook, and then click the Enable Content button on the warning bar.

How to enable macros in all workbooks via Trust Center →

​

Microsoft Excel determines whether to allow or disallow VBA codes to run based on the macro setting selected in the Trust Center, which is the place where you configure all the security settings for Excel.

To get macros enabled in all Excel workbooks by default, this is what you need to do:

Click the File tab, and then click Options at the very bottom of the left bar.

On the left-side pane, select Trust Center, and then click Trust Center Settings….

      

In the Trust Center dialog box, click Macro Settings on the left, select Enable all macros and click OK.

      

Hope this help.

• Related Articles

• TDS || Excel export and Import Procedure

  To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...

• TDS || Correction → Excel export and Import Procedure

  The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...

• eXBace || Data import and export through excel

  To reduce complications of data entry In eXBace software, a facility has been provided where the user can import data through excel and can export data in excel. The User can also validate every sheet where the data is entered at the same time. The ...

• ExpressTDS || Download TDS Return Data in Excel

  Steps to Download TDS Return Data in Excel Format via ExpressTDS You can download TDS return data for both regular and correction returns in Excel format. Ensure transactions have been created in the return before proceeding. Here’s how: Download TDS ...

• Income Tax || How to export Client Master Data in Excel

  Exporting client details in an Excel sheet from the Income Tax Software is a straightforward process. Here's a step-by-step guide: Step 1: In the Income Tax Software, navigate to Reports → MIS → MIS option in the menu bar. Step 2: Click on the ...