Step 1: Open VBA Locate the sheet whose columns you want to adjust automatically, and right-click the sheet tab at the bottom of the Excel window. Then, click "View Code." ...

Move Macros to a new Module. Enable trusted access to VBA. Review your VBA code. Repair Microsoft Excel. Uninstall, and then reinstall Excel. Some other methods, like scanning for malware, etc ...