| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar sub Menus
Hi everyone
I am creating a toolbar based on an example from chip pearson which works perfectly with one sub menu. Ideally what i need is up to 3 sub menus eg Fruit Apples Green Rotton Good red Rotton Good Oranges Spanish Very Big Big Small Somewhere else Very Big Big Small Veg ....and so on. For some reason it won't let me create these extra submenus and puts them all in one big list. If anyone is familiar with this method ( using a seperate sheet to define all the items and levels on a menu) Then I would very much appreciate your help. Thanks for your time. Jon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toolbar sub Menus
Do you mean John
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jon" wrote in message ... Hi everyone I am creating a toolbar based on an example from chip pearson which works perfectly with one sub menu. Ideally what i need is up to 3 sub menus eg Fruit Apples Green Rotton Good red Rotton Good Oranges Spanish Very Big Big Small Somewhere else Very Big Big Small Veg ...and so on. For some reason it won't let me create these extra submenus and puts them all in one big list. If anyone is familiar with this method ( using a seperate sheet to define all the items and levels on a menu) Then I would very much appreciate your help. Thanks for your time. Jon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toolbar sub Menus
Do you mean John Walkenbach's MenuMakr routine?
What do you have on the worksheet, all the data? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jon" wrote in message ... Hi everyone I am creating a toolbar based on an example from chip pearson which works perfectly with one sub menu. Ideally what i need is up to 3 sub menus eg Fruit Apples Green Rotton Good red Rotton Good Oranges Spanish Very Big Big Small Somewhere else Very Big Big Small Veg ...and so on. For some reason it won't let me create these extra submenus and puts them all in one big list. If anyone is familiar with this method ( using a seperate sheet to define all the items and levels on a menu) Then I would very much appreciate your help. Thanks for your time. Jon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toolbar sub Menus
Hi Jon
See mr Erlandsens page http://www.erlandsendata.no/english/...nvbacbmenuxl97 on code for sub-sub-menus. HTH. Best wishes Harald "jon" skrev i melding ... Hi everyone I am creating a toolbar based on an example from chip pearson which works perfectly with one sub menu. Ideally what i need is up to 3 sub menus eg Fruit Apples Green Rotton Good red Rotton Good Oranges Spanish Very Big Big Small Somewhere else Very Big Big Small Veg ...and so on. For some reason it won't let me create these extra submenus and puts them all in one big list. If anyone is familiar with this method ( using a seperate sheet to define all the items and levels on a menu) Then I would very much appreciate your help. Thanks for your time. Jon |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toolbar sub Menus
I have a CommandBar example on my website (sub sub menus)
-- Rob van Gelder - http://www.vangelder.co.nz/excel "jon" wrote in message ... Hi everyone I am creating a toolbar based on an example from chip pearson which works perfectly with one sub menu. Ideally what i need is up to 3 sub menus eg Fruit Apples Green Rotton Good red Rotton Good Oranges Spanish Very Big Big Small Somewhere else Very Big Big Small Veg ...and so on. For some reason it won't let me create these extra submenus and puts them all in one big list. If anyone is familiar with this method ( using a seperate sheet to define all the items and levels on a menu) Then I would very much appreciate your help. Thanks for your time. Jon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving customized toolbar and menus | Excel Discussion (Misc queries) | |||
| Toolbar and menus are frozen | Excel Discussion (Misc queries) | |||
| Workbook Specific Toolbar Menus | Excel Discussion (Misc queries) | |||
| Drop Down Menus in Toolbar | New Users to Excel | |||
| Custom menus and toolbar text and icons | Excel Programming | |||
Linear Mode
