'Trouble with excel macros (possibly encoding?)
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
Solution 1:[1]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |