VBE The XLSM file can't save macros

Two computers: On my personal computer, the VBE module shows 'no open projects,' most of the buttons are greyed out, and if I try to click any non-greyed button, it gives an 'error in loading DLL.'

On my work computer, the issue is: after creating a new XLSX document and saving it as an XLSM file, it opens fine; however, once I insert a Macro, it shows that the file is corrupted, and repairing it deletes my macro.

I’ve tried reinstalling, adding trusted folders, modifying the registry, and rolling back to version 2607, but nothing worked.

The personal computer is set to the US region and I downloaded the English version of 365, while the work computer is set to CN and I downloaded the Simplified Chinese version of 365.

Also, the USER folder on my personal computer was moved to the D drive.

I contacted Microsoft support, and the staff suggested I post in this community .