View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default excel 2007 customize quick access toolsbar adding menus commands

In the terms you want to do this it is not possible. That is you cannot
simply drag a button to the QAT as you could on the old toolbars.

You can write some code to add the button to the 'add-in' tab and then right
click on it here to add it to the QAT or you could write your own tabs in
ribbonX

These are about your only customisation options I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Søren Thade Petersen" wrote
in message ...
I have added a "Menu Commands" to the Quick Access Toolbar in Excel 2007.

But I cannot find out how to:

1) Add Commands to the "Menu Commands"
2) Change the "Menu Commands" name.

I would like to make a menu-item on the Quick Access Toolbar, in which i
have several commands. And even sub-menus of this menu-item.

In other words I would like to make the transition much easier to "old"
Excel 2003/Excel XP users.

Thanks in advance!