Trouble with excel macros possibly encoding

Question

We share and edit an excel spreadsheet that is set up in our workplace across six computers, and one day, out of the blue, one of the PCs starts to have macro issues. Macros that have had their names changed to include letters with diacritical marks, as if the encoding had been altered but only on one computer, function normally. Additionally, it added the filename before the macro name. How can this be fixed?

Answer 1

To solve your issue:

• Replace your macro names with English ones to ensure they work in every region worldwide.
• or check your region settings and ensure every computer uses the same settings and same codepage.