Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks

Anthony

After you get the "New Menu" on the Toolbar, scroll up to "Macros" Command in
same dialog box and select it.

Drag "Custom Menu Item" up to the New Menu. An empty gray box will appear
attached to the lower left corner of New Menu.

Drop the Custom Menu Item onto that gray box.

Give it a name you like by right-click and type in a name where it says
"Name".

Do this as many times as you want.

You will then have to assign a macro to that/those item(s) to run code for
opening the separate worksheet(s).


Gord Dibben Excel MVP


On Thu, 24 Feb 2005 13:31:12 -0800, "Anthony"
wrote:

Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks

Gord,
Thanks so much, thats fantastic - told you it was easy when you know how.

I may come back if I have another question related to this, but for now
thanks again

Regds

Anthony

"Gord Dibben" wrote:

Anthony

After you get the "New Menu" on the Toolbar, scroll up to "Macros" Command in
same dialog box and select it.

Drag "Custom Menu Item" up to the New Menu. An empty gray box will appear
attached to the lower left corner of New Menu.

Drop the Custom Menu Item onto that gray box.

Give it a name you like by right-click and type in a name where it says
"Name".

Do this as many times as you want.

You will then have to assign a macro to that/those item(s) to run code for
opening the separate worksheet(s).


Gord Dibben Excel MVP


On Thu, 24 Feb 2005 13:31:12 -0800, "Anthony"
wrote:

Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks

Anthony

If you're still watching......if not, maybe someone else will benefit.

Just a caveat here.........

The customizations are saved in a file named *.xlb with the * being your
version of Excel

i.e. Excel10.xlb or Excel11.xlb

Too many customizations will tend to bloat this *.xlb file and can cause
problems with Excel.

Best to keep customizations to a minimum.

Building menus and toolbars "on the fly" is the way to go if need a lot of
customizing.

Code in the workbook will build the menus and toolbars when it opens and
deletes them when it closes.

A good example of this and a customizable workbook can be downloaded from John
Walkenbach's site

http://www.j-walk.com/ss/excel/tips/tip53.htm

Gord

On Thu, 24 Feb 2005 16:17:02 -0800, "Anthony"
wrote:

Gord,
Thanks so much, thats fantastic - told you it was easy when you know how.

I may come back if I have another question related to this, but for now
thanks again

Regds

Anthony

"Gord Dibben" wrote:

Anthony

After you get the "New Menu" on the Toolbar, scroll up to "Macros" Command in
same dialog box and select it.

Drag "Custom Menu Item" up to the New Menu. An empty gray box will appear
attached to the lower left corner of New Menu.

Drop the Custom Menu Item onto that gray box.

Give it a name you like by right-click and type in a name where it says
"Name".

Do this as many times as you want.

You will then have to assign a macro to that/those item(s) to run code for
opening the separate worksheet(s).


Gord Dibben Excel MVP


On Thu, 24 Feb 2005 13:31:12 -0800, "Anthony"
wrote:

Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks

Gord,
Thanks for that info , will give it a go.
Can you possibly help with my latest question??
see 'Add a Message Box' in the Excel Worksheet Functions pages
thanks again
"Gord Dibben" wrote:

Anthony

If you're still watching......if not, maybe someone else will benefit.

Just a caveat here.........

The customizations are saved in a file named *.xlb with the * being your
version of Excel

i.e. Excel10.xlb or Excel11.xlb

Too many customizations will tend to bloat this *.xlb file and can cause
problems with Excel.

Best to keep customizations to a minimum.

Building menus and toolbars "on the fly" is the way to go if need a lot of
customizing.

Code in the workbook will build the menus and toolbars when it opens and
deletes them when it closes.

A good example of this and a customizable workbook can be downloaded from John
Walkenbach's site

http://www.j-walk.com/ss/excel/tips/tip53.htm

Gord

On Thu, 24 Feb 2005 16:17:02 -0800, "Anthony"
wrote:

Gord,
Thanks so much, thats fantastic - told you it was easy when you know how.

I may come back if I have another question related to this, but for now
thanks again

Regds

Anthony

"Gord Dibben" wrote:

Anthony

After you get the "New Menu" on the Toolbar, scroll up to "Macros" Command in
same dialog box and select it.

Drag "Custom Menu Item" up to the New Menu. An empty gray box will appear
attached to the lower left corner of New Menu.

Drop the Custom Menu Item onto that gray box.

Give it a name you like by right-click and type in a name where it says
"Name".

Do this as many times as you want.

You will then have to assign a macro to that/those item(s) to run code for
opening the separate worksheet(s).


Gord Dibben Excel MVP


On Thu, 24 Feb 2005 13:31:12 -0800, "Anthony"
wrote:

Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks