Give the cell or range a name

Sub get_there()
Application.Goto Reference:="MyRange" ', Scroll:=True 'optional
End Sub

You can do the same thing without using code or buttons......just Insert
Hyperlink and point to the cell in the other workbook.


Gord Dibben MS Excel MVP


On Mon, 15 Jan 2007 12:10:02 -0800, Anand vijay
wrote:

How do i create hyperlink for buttons so that whrn i click on button i go to
another sheet in same workbook at a perticular point?