Excel crashes as soon as macro is enabled

Hi Everyone, I have an Excel macro utility which I maintain and is used by 100+ users in my team across the globe. The utility is heavy on automation using VBA. It worked fine for everyone until recent times when few of the users have started coming up with Excel crashing when the file is opened and the macros are enabled.

As part of the support group in the team, I get the files from them which had crashed but strangely I am able to open the file without any issues. I then go to the VBA code editor and compile the code, then send it to them and miraculously it starts working for them. Unfortunately, I can't share the password to the users to perform this themselves to fix the file.

I checked the version of Excel and it was a newer version than what I have and all runs on Windows 11. I tried few of the troubleshooting posted in the link below but nothing helped.

And one more strange observation is that the users facing the issue are all from North America region while I am from India. I don't know if that has got anything to do with the issue.

Attaching the snapshot of the Excel version.

I am looking for a permanent fix for the issue. Any suggestions are greatly appreciated.