Create Simple Button Script

[team4344]

Hello im using Excel 97. I would simply like to create a button which, when clicked on will take you to another worksheet in the same spreadsheet.. I have created a commadn button via the toolbox, but im not sure where to go from here..
Can anyone help... this is the code that i have at the moment. What do i need to add

==============================

Private Sub CommandButton12_Click()


End Sub

==============================

Many thanks for everyones help in advance (",) its much appreciated.

Regards

Ollie

 

[JohnAcc]

Hi There, You just need,

Private Sub CommandButton12_Click()
Sheets("Sheet2&quot.Select
End Sub

Where sheet2 is the name of the sheet you want to go to

Rgds, john