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.
To export GSTR-2 returns Data in the MS Excel follow the steps below : Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2 Make sure that there are no items under the section Not included in returns due to incomplete information ...
To export GSTR-1 returns in the MS Excel follow the steps below : Steps 1 : Gateway of Tally > Display > Statutory Reports > GST > GSTR-1. Alternatively, Press Alt+G (Go To) > Type Here or Search GSTR-1 > Press Enter. Step 2 : F2: Period: Select the ...
Error in Loading DLL in excel export / Automation error - Library not registered in Excel export Solution : NOTE : This is not Software Related issue. Usually error in loading dll Excel arise when due to the installation of any software the new DLL ...
3CD annexure export Process - "Interest details paid u/s 201 (1A)/206C(7)" This process helps the user to export/ import the 3CD details entered for a particular PAN in TDS Software to the Income Tax Software using an excel template format easily. ...
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 ...