Follow the steps below to How to enable and use VBA in Excel: Launch Excel. On the Developer tab, click the Visual Basic button. Click the Insert tab and select Module in the menu.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

To prevent Excel from disabling an add-in, you should use Excel add-ins from trusted sources only. Once you do this, this ensures that Excel recognizes the add-in as safe and avoids any disruptions.

Microsoft says the Excel spreadsheet software is now blocking untrusted XLL add-ins by default in Microsoft 365 tenants worldwide.