Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-14-2023, 11:32 AM
Ddadoo57 Ddadoo57 is offline How to show or hide the QAT (Quick Access Toolbar) in vba ? Windows 11 How to show or hide the QAT (Quick Access Toolbar) in vba ? Office 2021
Advanced Beginner
How to show or hide the QAT (Quick Access Toolbar) in vba ?
 
Join Date: Feb 2023
Posts: 90
Ddadoo57 is on a distinguished road
Default

Good evening Guessed and thank you for your feedback!

Yes you are right, but it's not a question for me to disable anything from the user, on the contrary as you say, it to bring an added value to his experience.

The idea I had with a custom QAT was to be able to link it to the custom ribbon for the user. In fact, in the case I encountered, I had no more space on the latter, and creating an additional tab for only a few items (needed only from time to time and under specific conditions), was not very ergonomic for my taste.

By default, startFromScratch="true" displays only the custom ribbon and the custom QAT.

Great that you can reset each tab with idMSo, I hadn't thought of that, thanks for the info! I think it's a bit like the Backstage?

Yes the idea of importing the .qat export file is also interesting... but the simplest would be that MS creates us a idMso for the QAT, as Application.CommandBars.ExecuteMso ("MinimizeRibbon") works for a ribbon.

With that I wish you a very good evening,
David
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add quick access toolbar in Excel Add-In? Mangesh1212 Excel 6 11-30-2018 02:05 AM
How to show FULL quick access toolbar? dylansmith PowerPoint 2 02-10-2018 12:53 AM
Quick Access Toolbar Word 13 namedujour Word 8 08-12-2015 10:37 AM
add macro to quick access toolbar TessaLee Word VBA 2 03-16-2011 06:31 PM
Quick Access Toolbar pmokover Word 0 10-30-2009 07:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft