A quick quesion:

Is there an easy way of determining the language version of Excel?

I am trying to fix up an app in Excel that includes the following line of
code:

Application.CommandBars("Tools").Controls("Protect ion").Enabled = False

This is used to prevent users from switching off protection (please no
comments on the method used - it is not my app, I've just been asked to fix
it).

The problem is that a few users have the German version of Excel and the
commands ("Tools" and "Protection") have different names.

I'd like to determine the language version of Excel and run the line above
(it its English) or a line using the German terms (if it is German).

I'm not confident about using the index values of the items in case the
menus have been modified at all. If there is some other method of specifying
the controls (that is not language/version specific) I'd be interested in
hearing about it.

Thanks

Paul

--
Visit my website www.pdtech.co.uk for Access Developer Resources