Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access menu
How do i access "About Microsoft Excel" from the Help menu bar?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access menu
Try
Sub test() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute End Sub See http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ernie" wrote in message ... How do i access "About Microsoft Excel" from the Help menu bar? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
access menu
I have this software installed with excel. its call ExcelShield. i need to
create a code to access "About" from ExcelShield menu bar. I'm trying the code below but it does not work: Sub test() Application.CommandBars("Worksheet Menu Bar").Controls.Application.CommandBars("Excel&Shie ld").Caption = _ "A&bout" End Sub -- help a friend help you "Ron de Bruin" wrote: Try Sub test() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute End Sub See http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ernie" wrote in message ... How do i access "About Microsoft Excel" from the Help menu bar? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
access menu
Adapt this example
Dim winHelpMenu As CommandBarControl Set winHelpMenu = Application.CommandBars("Worksheet Menu Bar").Controls("Help") winHelpMenu.Controls("About Microsoft Office Excel").Execute -- Regards Ron de Bruin http://www.rondebruin.nl "ernie" wrote in message ... I have this software installed with excel. its call ExcelShield. i need to create a code to access "About" from ExcelShield menu bar. I'm trying the code below but it does not work: Sub test() Application.CommandBars("Worksheet Menu Bar").Controls.Application.CommandBars("Excel&Shie ld").Caption = _ "A&bout" End Sub -- help a friend help you "Ron de Bruin" wrote: Try Sub test() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=927, Recursive:=True).Execute End Sub See http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ernie" wrote in message ... How do i access "About Microsoft Excel" from the Help menu bar? |
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) | |||
access menu | Excel Programming | |||
I have no access to the "tabs" on the options menu of excel | Excel Discussion (Misc queries) | |||
Access menu item from VBS | Excel Programming |