Great site and tutorial.
now it works!

thanks a lot
s. wiederkehr


"Ron de Bruin" wrote:

See
http://www.rondebruin.com/menuid.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"swiederkehr" wrote in message ...
Hello

How can i disable controls like File - New?

The Code:
- Application.CommandBars["File"].Controls["New..."].Enabled = false;

works fine, but i want to use an index instead of the name "File" like:

- Application.CommandBars[1].Controls[1].Enabled = false;

So i can use different Excel versions (English, German, French,...).

thanks for the help
s. wiederkehr