A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Folks, our shared UX controls team have been following this thread (and others), as well as your requests on UserVoice and are spinning up some work to address your concerns. I can't promise a specific date for getting this work out to you all, but they recognize the impact this has had on those of you who work with customized QAT and are moving very quickly.
When they're done you'll see the improvement arrive as part of the regular updates we send all subscription customers.
Thanks again for the clear feedback, both here and on UserVoice - keep it coming!
Cheers...pc
In the context of improving usability of QAT, I use a lot of tables and distribute workbooks to 'users'. If putting the cursor in the table, the Table Tools - Design tab [TTD] pops in and slashes the QAT in half. Even with the workbook protected, the DDT comes and does this, [When the ribbon in protect has about zero useable functions, except 'Refresh All [rest grayed, when I have the books loading with extra refresh buttons on QAT already. In short, as a user, the design tab has -zero- function. Yes, I could put the QAT below the address / formula / entry input bar, but this is not how most work.... we want max work area when it's needed.
Anyway, short story, options to -not- get certain ribbon push their foot in sideways would improve the QAT use substantially, with or without the excessive button spacing. The same book has custom shapes on the sheet with assigned macros. At least the the Drawing Tools and Picture Tools ribbon tabs do not pop in.
(Looked for a VBA solution, but [sorry for you] searched with Google and could not find any references to achieve the matter programmatically)