Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Caller with sub-menu selection in 2007
I use the Application.Caller to return the menu item from a menu containing
sub-menus that each use the same macro function. While the upper level items still work, there is no longer any differentiation for the sub-menu items. Code did work for 2003 and earlier but not for 2007. Have I missed something ? dim c as variant c= Application.Caller if c(4)= 0 then ' menu item 'select actual course of action select case c(1) case 1 case 2 case else end select elseif c(4) = 11 then ' 11th item in menu is a sub-menu 'select actual course of action for sub-menu select case c(1) case 1 case 2 case else end select endif TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Caller with sub-menu selection in 2007
I don't use XL2007, but the "ActionControl" property may still work. Give it a try. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Kevin Beckham" wrote in message I use the Application.Caller to return the menu item from a menu containing sub-menus that each use the same macro function. While the upper level items still work, there is no longer any differentiation for the sub-menu items. Code did work for 2003 and earlier but not for 2007. Have I missed something ? dim c as variant c= Application.Caller if c(4)= 0 then ' menu item 'select actual course of action select case c(1) case 1 case 2 case else end select elseif c(4) = 11 then ' 11th item in menu is a sub-menu 'select actual course of action for sub-menu select case c(1) case 1 case 2 case else end select endif TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Caller with sub-menu selection in 2007
Thanks Jim
I didn't want to have to set a different ActionContol (and hence different processing procedure) for each menu item, 30-40 including sub-menus, as the handling is essentially the same. The code still works for the items on the menu but not for item on sub-menus, i.e. Caller is broken in 2007 Kevin "Jim Cone" wrote: I don't use XL2007, but the "ActionControl" property may still work. Give it a try. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Kevin Beckham" wrote in message I use the Application.Caller to return the menu item from a menu containing sub-menus that each use the same macro function. While the upper level items still work, there is no longer any differentiation for the sub-menu items. Code did work for 2003 and earlier but not for 2007. Have I missed something ? dim c as variant c= Application.Caller if c(4)= 0 then ' menu item 'select actual course of action select case c(1) case 1 case 2 case else end select elseif c(4) = 11 then ' 11th item in menu is a sub-menu 'select actual course of action for sub-menu select case c(1) case 1 case 2 case else end select endif TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
Menu Selection as an Event | Excel Programming | |||
if selection from drop down menu = X, then... | Excel Programming | |||
Disable menu selection | Excel Discussion (Misc queries) |