help with excel macro 2003

[kwat1]

Hello All,

I am familiar with how to a create a simple macro in excel, however say that I have several worksheets and (e.g.) A,B,C,D, etc. Say that tab A is the home page and the other tabs are some other type of info. on the home page i want to create buttons that when i click on them they automatically go to the specific page. say that i want to click the button and go to tab B from the home page. How do i create that type of macro?

thanks in advance!

 

[tweedle]

There's a version of this using a ComboBox on the worksheet here:
http://www.mrexcel.com/forum/showpost.php?p=2817020&postcount=2

 

[kpark91]

Hi, you can start by first creating your desired buttons on your 'homepage'
Then by double-clicking or using click event of the buttons, you can include these kinds of code

_Click()
    Worksheets("B").Activate
End Sub

This will go to tab B from the 'homepage'

 

[AlphaFrog]

This macro selects Sheet B

Sub Macro1()
    Sheets("B").Select
End Sub

 

[kwat1]

Thank you for the help it worked perfectly.