Excel 2021 error 75

zeevbngmailcom 

OK, looks as if the VBA project of the file is corrupted. You can fix it as follows:

1. Open the current file
2. Save-as, select file type xlsx
3. Click Yes to the prompt that you'll lose the code
4. Close the newly saved file
5. Now open both your new xlsx and your old xlsm file
6. Open the VBA editor
7. Double-click Sheet1 in the xlsM project
8. Select all code in the window and hit control+c
9. Double-click Sheet1 in the xlsX project
10. Paste in the new window
11. Repeat steps 7-10 for all other worksheets
12. Repeat steps 7-10 for ThisWorkbook
13. Drag any modules, userforms and class modules from the xlsm to the xlsx file
14. Close the VBA editor
15. Save-as the xlsx file to Excel workbook with macros.