Excel - Quick Access Toolbar - customise with a drop-down menu
Excel - Quick Access Toolbar - customise with a drop-down menu
(OP)
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!
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
RE: Excel - Quick Access Toolbar - customise with a drop-down menu
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
RE: Excel - Quick Access Toolbar - customise with a drop-down menu
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
RE: Excel - Quick Access Toolbar - customise with a drop-down menu
combo