Hello,
maybe I have to study better vba programming but I'm not able to solve this problem by myself.
I created the code that should activate the "rectangle" function of the commandbar "drawing". This is the code line that works well:
Application.CommandBars("Drawing").Controls("Rectangle").Execute
but, if I copy the code in a pc with excel in a language other than english the code doesn't work (in my case the language is italian). This is because the italian name of the control rectangle is "rettangolo". I thought to solve the problem by using the ID of the control (for the commandbar "drawing" and the control rectangle is 1111) so the code would work both in the english and italian version. But I was wrong.
Application.CommandBars("Drawing").Controls(1111).Execute
Where I'm wrong? I need to write the code that works in the two versions of excel...
Thanks in advance to those who wants to help me.
Bookmarks