Trouble with excel macros (possibly encoding?)

user_16116276 0
Viewed 112

We have in our office setted system in excel sheet, which we share and editing all together (6 computers) and one day from middle of nowhere, one of the computers starts to have troubles with macros. Macros which have in name letter with diacritics renamed, like if the encoding was changed but its just on one computer, others work fine. Also it added name of the file beffore the macro name. How to solve this? Thanks

enter image description here

encoding vba excel
1 Answers

Easiest workaround way is to rename them and not use any odd characters besides english ones. Any other characters can cause issues depending on the region settings of the computer using it.

So if using different region settings on different computers: Do not use foreign characters in your VBA editor, or you can run into such issues.

To solve your issue:

  • Replace your macro names with english ones to ensure they work in every region world wide
  • or check your region settings and ensure every computer uses the same settings and same codepage

Also see How To Display Foreign Characters In Excel VBE

user_32196130
Related