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.

Thanks alot!

Hi Guys,

So I applied the macro's you've provided, the macro works terrfic in the scrap-book. The problem is when I try to insert the code to my actually workbook the macro does not seem to work? How Can I fix this issue? Please advise. My starting point is cell G30 instead of C13 and I have about 80tabs. I played around with teh ranges and it still doesnt seem to work.