Custom Menus
 

I am experimenting with custom menus and was wondering if there was
way to find which root menu an item was selected from.

ie.
Custom Menu "Fred"

Contains three sub menus
"Barney", "Betty", "Wilma"

Each containing a menu of various selectable options

When the items are selected can I tell programatically which sub men
the selected item is found in (Barney, Betty or Wilma)

--
fazst
-----------------------------------------------------------------------
fazstp's Profile: http://www.excelforum.com/member.php...fo&userid=3057
View this thread: http://www.excelforum.com/showthread.php?threadid=50797

Custom Menus
 

Try

With Commandbars.ActionControl
Msgbox .Parent.Caption
End With

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"fazstp" wrote in
message ...

I am experimenting with custom menus and was wondering if there was a
way to find which root menu an item was selected from.

ie.
Custom Menu "Fred"

Contains three sub menus
"Barney", "Betty", "Wilma"

Each containing a menu of various selectable options

When the items are selected can I tell programatically which sub menu
the selected item is found in (Barney, Betty or Wilma)?


--
fazstp
------------------------------------------------------------------------
fazstp's Profile:
http://www.excelforum.com/member.php...o&userid=30574
View this thread: http://www.excelforum.com/showthread...hreadid=507972

Custom Menus
 

Fazstp,

Could you use .parent ?

Pete




"fazstp" wrote:


I am experimenting with custom menus and was wondering if there was a
way to find which root menu an item was selected from.

ie.
Custom Menu "Fred"

Contains three sub menus
"Barney", "Betty", "Wilma"

Each containing a menu of various selectable options

When the items are selected can I tell programatically which sub menu
the selected item is found in (Barney, Betty or Wilma)?


--
fazstp
------------------------------------------------------------------------
fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574
View this thread: http://www.excelforum.com/showthread...hreadid=507972