Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-13-2023, 07:35 PM
Guessed's Avatar
Guessed Guessed is offline How to show or hide the QAT (Quick Access Toolbar) in vba ? Windows 10 How to show or hide the QAT (Quick Access Toolbar) in vba ? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm not sure where you are going with this project but it is generally considered poor form to disable/hide all the functionality that a user may have customised for their own purposes - such as the QAT and Normal.dotm template contents. I prefer my templates to augment the user experience rather than remove familiar capabilities - leading a horse to water rather than forcing them to drink. That being said...

Does startFromScratch hide the QAT too? I've never used that setting myself. If that appears to be the only way to hide the QAT then you could reinstate each of the various ribbon tabs with xml. Just include the idMso for each tab.

Another alternative might be to export the existing QAT as the template opens, then remove all buttons. A separate macro could then re-instate the exported QAT as you close the template. This might be quite complicated if there are multiple templates (Normal, attached or add-ins) which each carry QAT customisations.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
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 11:35 AM.


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