Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2023, 07:49 AM
MartinGM MartinGM is offline Show/Hide custom ribbon tab Windows 11 Show/Hide custom ribbon tab Office 2021
Advanced Beginner
Show/Hide custom ribbon tab
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default Show/Hide custom ribbon tab

When I open a particular Workbook, I would like a specific custom ribbon tab to become visible, and for it to be hidden whan I close this Workbook.



I know how to capture the Workbook open and close events, and to test for the filename, but taking it from there the only ways to show or hide a custom ribbon tab seem way above my pay grade !

Is there a reasonably simple way to show / hide a custom ribbon tab from VBA ?

Or maybe an Excel Add-in ?

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Ribbon modification leurne Word VBA 8 08-11-2023 06:26 AM
Show/Hide custom ribbon tab Is it possible to show more Word styles in the ribbon? andiekit Word 7 09-24-2019 01:24 AM
Show/Hide custom ribbon tab How do I keep the ribbon (tabs: File, Home, Insert, Design, Layout, etc.) up and not hide? eloiset Word 3 10-06-2018 06:12 PM
Custom Tab on the ribbon missing TechEd Word 2 09-14-2011 05:08 PM
Hide command group labels in ribbon jtay Word 0 06-14-2011 10:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 AM.


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