Problem with macros after using Office 365 for a few days

[Martin_H]

Hi team,

so I switched from Office 2016 straight to Office 365, used it for a few days and went back to Office 2016.

Now a few VBA macros are not working for me, but they still work on my colleagues computers who are still using Office 2016.

Could this be caused by the cache?

Any idea how to solve this problem so I can run those macros on my computer with Office 2016 as I used to?

 

[Candyman8019]

In your VB window go to Tools | References and compare your settings to your colleagues.

 

[Martin_H]

In your VB window go to Tools | References and compare your settings to your colleagues.
View attachment 89200

Tried it but the problem still persists.

 

[Candyman8019]

Are you getting any specific errors?

 

[Martin_H]

Yes, errors like it can't find the path etc, but it finds the path on my colleagues' computers without any problems.

I think the problem might be with accented characters like: à, è, ì, ò, ù, À, È, Ì, Ç, Ù because they don't display correctly in my VBA window.

Is there any way to display these characters correctly on my VBA window?

 

[Candyman8019]

I have never changed that setting, but I would guess that is related to what default language/keyboard you have set in Windows.

 

[Martin_H]

A problem was found in this setting (Region tab).

Specifically under Current language for non-Unicode programs which was set to foreign language (English).