Hi All,

Can any one help me to write a vba code to navigate between worksheets with a command button.

I tried with hyperlink method but i suppose i was going wrong in writing the code.

Any help or suggestion is highly appreciated.

Thanks in advancePrivate Sub CommandButton1_Click()

    ActiveWorksheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "Sheet3!A1", TextToDisplay:=""
End Sub

Following line in the "on click" event of your command button will take you to Sheet2. (If this is what you were looking for . . .)

Sub Button1_Click()
    Sheets("Sheet2").Select
End Sub