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
|