Custom Tab in Ribbon - How to attach to one particular file?

[MattGreer]

I searched but didn't find this referenced to Excel 2010 or greater. I'm using Excel 2013.

I have a file that contains a table of items that I sort and manipulate and apply formatting and so forth using macros. I wanted to add those macros to a custom Tab, so I did. Problem is that Custom Tab shows up whenever I open Excel now, rather than just being attached to that one file (which is what I want).

How do I set up a custom Tab that only opens when I open the file that contains the source VBA?


Thanks!!


Matt

 

[Andrzejek]

Since you "have a file {...} using macros", you may as well add a little code to add your Tab to your Ribbon just for that file, and not the others:

Option Explicit

Private Sub Workbook_Open()
    AddMyTabToRibbon
End Sub

Sub AddMyTabToRibbon()[green]
'Some code here to do that
[/green]
End Sub

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[mintjulep]

And more to remove it when you close.

 

[TonyJollans]

This is not as straightforward as it ought to be, but a good starting point is Microsoft Excel MVP, Ron de Bruin's web page:

https://www.rondebruin.nl/win/s2/win001.htm

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website