Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Quick Access Toolbar - customise with a drop-down menu

Status
Not open for further replies.
pendle666

pendle666

Technical User
Jan 30, 2003
295
GB
Hello there,

I have a lot of useful shortcuts and macros on my QAT in Excel.

Some of them I'd like to group into a sub-menu. Just like the regular ribbon has groups and sub-menus.

I can't see how to do this, but I'm guessing it's not an option, but has anyone found how to do this? Or are there any suggestions on managing groups of macros?

thanks!

thank you for helping

____________
Pendle
 
Sort by date Sort by votes
*** solved it****

So what I did was

create a new custom tab with my items in groups

Then right-clicked the group and added to quick access toolbar and there is a blue blob with the items underneath.

Haven't worked out how to change the icon - but that's fine with me.

thank you for helping

____________
Pendle
 
Upvote 0 Downvote
MS info how to sustomize QAT here.

One of blogs here.

To add menus to QAT: you can create your own ribbon with groups of macros, customize items (in the designer select icon and 'change name...' option), and hide it. Next, when customizing QAT, it is possible to add ribbon's group to QAT. Items in QAT are displayed only as icons, but with tooltips.

combo
 
Upvote 0 Downvote
To change icon, modify the source group in the ribbon: 'change name' command allow to change icon too. The change will be transferred to QAT.

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Avayacoolstuff
  • Locked
  • Question
MS quick query question
Replies
1
Views
308
PatrickRoggers
PatrickRoggers
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
322
combo
combo
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
893
renigar
renigar
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
1K
dhookom
dhookom
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
735
techguy2010
techguy2010

Part and Inventory Search

Sponsor

Back
Top