See the "Menus In Excel97 And 2000" page on my web site for information
about doing this either manually or with VBA code.
http://www.cpearson.com/excel/menus.htm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
ch...@cpearson.com
"David E. Hulme" <da...@aedis.demon.co.uk> wrote in message
news:CZbrMLAM...@aedis.demon.co.uk...
...I think by now you'll figure the rest out for yourself...
Patrick
____________
--
David E. Hulme
Thanks anyway for giving me a cup of perseverance.
If you are still in a generous mood...
For some reason the macro when called by the above method does not wait
for a click, it starts when hovered over the new menu. Ideas?
Regards, David H.
--
David E. Hulme
I 'customise the HELP menu by dropping in a Custom Menu Item from the
Macros category of the Commans tab, then I assigned a macro to the new
menu item.
I found that this worked 'normally' in that I had to 'click' the item
to call the code.
The topic is customize toolbars and it looks like this:
===========================
Customize toolbars
Click the topic that covers what you want to know.
Change the image or text on a toolbar button or menu command
Create a toolbar
Add a button to a toolbar
Add a built-in menu to a toolbar
Add a custom menu to a toolbar
Change the width of a drop-down list box on a toolbar
Copy an image from one toolbar button or menu command to another
Delete a menu from a toolbar
Display text or an icon on a toolbar button
Group related buttons and menus on a toolbar
Rename a custom toolbar
Rename a menu command or toolbar button
Restore original settings for a built-in toolbar button or menu command
Show or hide toolbar ScreenTips
Run a macro from a toolbar button
Attach a custom toolbar to a workbook
Delete a custom toolbar
Restore original buttons and menus for a built-in toolbar
Save more than one toolbar configuration
=================================
Each of those topics has a link to a help page.
In the help menu I selected Contents and Index
I went into the Find tab and searched on Customize
This resulted in 3 main topics. I selected the first (the second works to)
which was a lowercase customize. I then scrolled pretty far down in the
lower listbox until I found "Customize toolbars" and I checked that box and
hit the display button.
Hope that helps.
Regards,
Tom Ogilvy
David E. Hulme <da...@aedis.demon.co.uk> wrote in message
news:W5euUKAE...@aedis.demon.co.uk...