Sheet2 is selected in the VBA Project Explorer pane in Excel. The SheetVeryHidden option in Excel's VBA Properties Window for Sheet2. The Save icon in Excel's VBA editor window.

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 ...