Excel Macros file

Macro files are refusing to open on my excel 2021 ive tried a lot of methods like repairing it using excel but it removes the vba file used for coding changed from Microsoft 2019 to 2021 ...