Macro-Button (form Control)

Hi All,

I am trying to create a reference macro-button. The idea of this is to create a macro, say you create it on the output page and then select your US tab. Then you would insert a button and assign that macro to it, so every time you click the US Tab macro button it will automatically transfer you to the US tab.

The problem is that I plan to add about 50+ sheets and I can’t create many excel buttons, since it will be overwhelming to the user. The question is, is there a way to create say a dropdown list with all the name of the tab and a Macro button adjacent to list and every time you change the name in your drop down list your macro would still work and transfer you to that tab?

I have included a scrap-work book with the basics that I have explained above, I just can’t seem to get it to work for the half (using the drop down list). Any suggestions will be most appreciative. Thanks in advance guys.