Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel97, VBA menu programming by ID Number.
i have the Italian version of Excel97 and there is not way that i known to patch it to american English language, to have formulas and menu in english. For my Excel97 the following code ... CommandBars("Worksheet menu bar").Controls("Help").Delete Does not mean anything, because is Italian Version, and instead of "Help" it has "?" So the following code is appropriate for the version. There is a common ID number for any version of Excel. Is better to use the ID Numbers when programming, to have more compatibility, I know how to restore a menu by name or by ID Number, Sub Restore_by_name() CommandBars("Worksheet menu bar").Controls.Add(Type:=msoControlPopup).Caption = "?" End Sub Sub Restore_by_ID_Number() CommandBars("Worksheet menu bar").Controls.Add Type:=msoControlPopup, Id:=30010, befo=10 End Sub I know how to delete a menu only by name, Sub Delete_by_name() CommandBars("Worksheet menu bar").Controls("?").Delete End Sub Sub Delete_by_ID_Number() ' ? End Sub How can i delete it by ID Number ? Any Help ? Thanks, Robert. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make items in a drop down menu reference a number | Excel Discussion (Misc queries) | |||
How do you change the default number of copies in the print menu? | Excel Discussion (Misc queries) | |||
Japanese excel97 on Eng Win XP pro sp2 | Setting up and Configuration of Excel | |||
Excel97 SDK: How to build a multi-lever menu using Excel SDK? | Excel Programming | |||
NEED HELP PROGRAMMING EXCEL TO AUTHENTICATE EXCEL USER ID AND LICENSE NUMBER WHEN TEMPLATES ARE USED | Excel Programming |