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

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

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

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

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