Assign this simple macro to the button

Public Sub GotoSheetB()
Application.Goto Worksheets("Sheet B").Range("A1")
End Sub

change the sheet name to suit.

You could also setup a hyperlink and link it to another sheet.

--
__________________________________
HTH

Bob

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:8c093a037a75e@uwe...
Dear sir,

I am knowing nothing about Visual Basic Program. However, I need it for
certain task which I feel it can help me a lot to manage my Excel
spreadsheet.


My question: I want to write a very simple visual basic program which
allow
me to reach a worksheet very quickly. My ideal situation is that press a
button in worksheet A and will reach worksheet B or other very quickly.
Is
there any quick program regarding my request?

Thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200810/1