| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access menu
i need help with the codes to access "about microsoft excel" from help in the
standard menu |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access menu
from the immediate window:
? CommandBars("Help").Controls(Commandbars("Help").C ontrols.count).Caption &About Microsoft Office Excel -- Regards, Tom Ogilvy "ernie" wrote: i need help with the codes to access "about microsoft excel" from help in the standard menu |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access menu
Tom's example give me my Google Search add-in (last one in the Help menu)
If you want to open it (works in every Language version) Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... from the immediate window: ? CommandBars("Help").Controls(Commandbars("Help").C ontrols.count).Caption &About Microsoft Office Excel -- Regards, Tom Ogilvy "ernie" wrote: i need help with the codes to access "about microsoft excel" from help in the standard menu |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access menu
Just an added thought.
Ron brings up a good point - that using the ID is more robust - however, all menu ids are not consistent across versions of excel. -- Regards, Tom Ogilvy "Ron de Bruin" wrote: Tom's example give me my Google Search add-in (last one in the Help menu) If you want to open it (works in every Language version) Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... from the immediate window: ? CommandBars("Help").Controls(Commandbars("Help").C ontrols.count).Caption &About Microsoft Office Excel -- Regards, Tom Ogilvy "ernie" wrote: i need help with the codes to access "about microsoft excel" from help in the standard menu |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access menu
menu ids are not consistent across versions of excel.
You are correct Tom But 927 is in Excel 97-2003 -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... Just an added thought. Ron brings up a good point - that using the ID is more robust - however, all menu ids are not consistent across versions of excel. -- Regards, Tom Ogilvy "Ron de Bruin" wrote: Tom's example give me my Google Search add-in (last one in the Help menu) If you want to open it (works in every Language version) Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... from the immediate window: ? CommandBars("Help").Controls(Commandbars("Help").C ontrols.count).Caption &About Microsoft Office Excel -- Regards, Tom Ogilvy "ernie" wrote: i need help with the codes to access "about microsoft excel" from help in the standard menu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Menu access problem | Excel Discussion (Misc queries) | |||
| Hotkey menu access on the MAC | Excel Discussion (Misc queries) | |||
| I have no access to the "tabs" on the options menu of excel | Excel Discussion (Misc queries) | |||
| Access menu item from VBS | Excel Programming | |||
Linear Mode
