Excel VBA error,may be is language error, and VBA will be deleted

Question

I need to work on a Japanese EXCEL to do VBA programming, and I set the area of my computer to Japan so that I can display the code that runs the workbook.

But But I found that whenever I added code to excel and then saved it, opening it again would report an error and delete my VBA.

Is there any solution except to change all macros to English names (that's too much work)

Answer 1

Hi,

It is necessary to ensure that the display language of the system is Japanese as the preferred language.

In addition, in the Office application, go to Options, Language, and check if the display language is Japanese.

Then in the VBA editor, click on Tools- Options- Editor Format- Font to make sure it is a Japanese font.

Try this method and let me know if you need more help, I'm glad to help you.