The Germany problem sounds like Germany is missing a Reference. Have them go
into the VBE and check for a 'Missing' Reference or build in the reference
via code. Check out "AddFromGuid" and "AddFromFile".
I don't know about the chart error, sorry.
HTH and Good luck,
Gary Brown


"ran010303" wrote:

I have an Excel spreadhseet that makes use of the VBA function str. When it
is run on a machine in Germany they get a error with the str function, as if
it is not part of the language.

Another user in the U.S. was trying to use the spreadsheet (run from their
network) and got a Compile Error: Automation Error with the line:
Private Sub LegendSetFont(ByRef cht as ChartObject)

The speadsheet works on my Office 2003 and Office 2002 versions of Excel.

Any suggestions will be appreciated.

Thanks.