Excel: Foreign Language Issues with commands


Hey All, Problem using English VBA commands on systems that use another language. For instance 'Russian or Mandarin' The following is an example of one of the problems we are encountering.


                       'English         English
Application.CommandBars("Cell").Controls("Copy").Enabled = False
I was able to find the ID numbers for the menu items so change the code to this:
'                               Was able to change the Copy command. 
Application.CommandBars("Cell").FindControl(ID:=19).Enabled = False
I found the commandbar ID number for the cell commandbar was 423 My question is what is the command to select the commandbar with it's ID number? Thanks for the time.


This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of August 15, 2014.


For more resources for Microsoft Excel