3. Go to Macro Settings and Select as shown below:
a. Enable all macros
b. Trust access to the VBA project object model.
4. Click Ok and complete the process.
5. Open Microsoft Excel again and Press Alt+F11 to check whether Macros have been enabled.
If you are not able to enable Macros from here, then it implies that while installing Microsoft Office
on your machine, Macros is not installed.
So what you need to do now is to repair or re-install your MS Office. To repair or reinstall MS office
please go to the Control panel > Programs and Features and right click on the MS Office version >
Choose Repair or reinstall.
If you are not able to reinstall or repair because of any reasons, please consult the Technical Support
team in your organisation.