View Single Post
 
Old 08-20-2023, 07:49 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 101
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