Hello every body !

I would like to know the exact english menu for VBA in excel

File, View etc...

But what I need above all, are the underlined letters for all these menus,
specialy the tools menu (T, O, L or S underline), and in this menu, what
about
Properties of VBAProject (which letter is underline)

I'm sure you have understood that I have not the US version with me ;-)))

I need this in order to use in a protection vba project by macro, and use
the "SendKeys" method. This might be operational either in French excel
version (that is mine, and the maco is OK) or US/UK version.

Lot of thank's in advance,

best regards,

Joël

Sub abc()
Dim ctr As CommandBarControl
For Each ctr In CommandBars("worksheet menu bar").Controls
Debug.Print ctr.Caption
Next
End Sub

&File
&Edit
&View
&Insert
F&ormat
&Tools
&Data
A&ction
&Window
&Help

Let me guess, you are thinking about SendKeys. Generally you can use
myControl.Execute, use commandbars.findcontrol(ID:=x), no
internationalization worries.

Properties of VBAProject (which letter is underline)

Do you mean View, &Project Explorer, but you can use Ctrl-R in all versions
(I guess?), but again better to use Excecute

Regards,
Peter T



"jojo" wrote in message
...
Hello every body !

I would like to know the exact english menu for VBA in excel

File, View etc...

But what I need above all, are the underlined letters for all these menus,
specialy the tools menu (T, O, L or S underline), and in this menu, what
about
Properties of VBAProject (which letter is underline)

I'm sure you have understood that I have not the US version with me ;-)))

I need this in order to use in a protection vba project by macro, and use
the "SendKeys" method. This might be operational either in French excel
version (that is mine, and the maco is OK) or US/UK version.

Lot of thank's in advance,

best regards,

Joël