- Open a blank workbook on MS Excel
- Got to File >> Options
- Click on Trust Center >> Trust Center Settings
- Click on Macro Settings >> Check ‘Trust Access to the VBA project object model’ (under Developer Macro Settings)
- Restart your Excel.
1 Like