What is VBA Macro and is it mandatory to enable it from Excel

[revivedpush.organization]

I need to run one macro script but its not running due to programmatic issue. wh3at should i do to enable it.

[raja.arslankhan (Raja Muhammad Arslan khan)]

@revivedpush.organization
Yes to run macro we need to enable macro option in Excel.
Macro itself nothing, its a line of code to perform specific action in excel. Its helpful to automate many task where to perform clicks/actions needed in excel file in specific fixed format.

1. Open a blank workbook on MS Excel
2. Got to File >> Options
3. Click on Trust Center >> Trust Center Settings

4. Click on Macro Settings >> Check ‘Trust Access to the VBA project object model’ (under Developer Macro Settings)

[revivedpush.organization]

@raja.arslankhan
Thanks for
quick response. How we can make macro VBA script

[raja.arslankhan (Raja Muhammad Arslan khan)]

@revivedpush.organization
Go to excel option → Enable developer mode from custom ribbon

Record your Marco by enabling recording.
After that you will perform all your steps which you want to do through macro.

You will get macro script from macros button.

[revivedpush.organization]

@raja.arslankhan wao nice. let me test

[revivedpush.organization]

@raja.arslankhan
yes resolved.