Try this
Private Sub CommandButton1_Click()
Sheets("Sheet 1").Select
End Sub

Private Sub CommandButton2_Click()
Sheets("Sheet 2").Select
End Sub

and so on

"ruben" wrote:

Hi, all

I am very new to this forum. but i know i can get all my answers here.

I have several commands buttons on an excel sheet and when i assigned a
hyperlink macro to say, when i click on cmd button A1, it leads me to Sheet2
B2. That's fine. but when i click on cmd button A2, it sends me to Sheet2B2
again. am quite new to VBA, macros and all that stuff and would like to have
help for me to have a macro which would enable me to have different worksheet
links assigned different command buttons

Thanks
ruben