The arrival of AMSI's VBA runtime scan in 2018 "effectively removed the armor that macro-obfuscation equipped malware with, exposing malicious code to improved levels of scrutiny," says Microsoft.

Excel Macros have made it possible for users to automate tasks that would otherwise require a lot of time and effort to execute. They can handle manual tasks in Excel, thereby enabling users to ...

Go to the Macro Settings tab. Tick the Trust access to the VBA project object model checkbox. Click the OK button. Then, restart Excel and check if the problem remains or not.