My VBA Help is in Japanese!

[John Uebersax]

I opened an Excel 2003 spreadsheet written by a Japanese colleague,
edited/ran a macro. In the process I consulted the VBA Help and the
information appeared in Japanese.

Then I closed the worksheet and opened Excel 2003 again from scratch.

Now within Excel my VBA Help continues to show information in Japanese
(but regular Excel Help is in English).

How can I change the VBA Help language back to English?

John U.

 

[joel]

Is the help on a microsoft web page. try cleaning out your cookies and
temporary internet files on your explorer. The IE explorer is just
remembering that previous used webpages.

 

[John Uebersax]

Thanks for your reply. I now see that the foreign language is
Chinese, not Japanese. The previous opening of a Japanese spreadsheet
was just a coincidence. The problem seems to be that my VBA help is
set by default to Chinese. Possibly this is related to the Windows or
Office installation of several Asian languages on my machine.

The question then becomes potentially simpler: how does one control
the language that VBA help is displayed in? Again, all my Excel
commands and Excel help appears in English. It's just the VBA help
that is in Chinese.

John

 

[joel]

I was told a couple of weeks ago the regional settings for Excel use
the Windows settings

Start - Control Panel - Regional and Language Settings

I'm not sure if that is always the case. There are registry setting
that can be changed.

In REGEDIT there is a setting

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\LanguageResources


You can delete any registry entry an the software doesn't find
required setting will set the option to its default condition. Not sur
what the above setting actually does.

There are some virus and spy where that can play tricks on your PC.
would run a virus checker to make sure there are not problems. Also ru
SPYBOT (or equivalent), and clear you internet browser history an
cookies