PC Review


Reply
Thread Tools Rate Thread

In 2007 Add new Tool button to keep custom macros for Workbook

 
 
Joe
Guest
Posts: n/a
 
      7th Dec 2007
In Excel 2003 I can keep all my assigned custom macro icons under a custom
menue on the toolbar. When clicked it opens a dropdown list showing all my
macros and their name tags.
How can I do this in Excel 2007 please?
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      7th Dec 2007
There are two ways to go on this. One is to learn how to customize the
ribbon using RibbonX. The other is to do an end run around the ribbon by
putting your menuitems on a popup menu. All credit to Ron de Bruin for
developing and demonstrating the second methodology here:

http://www.rondebruin.nl/qat.htm

Ron also has plenty of information on customizing the ribbon too.

--
Jim
"Joe" <(E-Mail Removed)> wrote in message
news:41766F8D-7354-47C0-9FAD-(E-Mail Removed)...
| In Excel 2003 I can keep all my assigned custom macro icons under a custom
| menue on the toolbar. When clicked it opens a dropdown list showing all my
| macros and their name tags.
| How can I do this in Excel 2007 please?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros button in the tool bar vanishes (Word) Xavier Microsoft Word Document Management 2 13th Dec 2007 08:21 PM
Custom Tool Button Editing... greg Microsoft Excel Misc 1 25th May 2004 07:37 AM
missing tool tip for custom button =?Utf-8?B?U3V6YW4=?= Microsoft Word Document Management 5 5th May 2004 11:21 PM
custom button on tool bar =?Utf-8?B?ZmFyb29x?= Microsoft Word Document Management 3 18th Feb 2004 07:32 PM
Copying a workbook with custom menus and macros =?Utf-8?B?UGFtIFI=?= Microsoft Excel Crashes 1 19th Jan 2004 09:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:04 PM.