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?

If I understand your question correctly ......

Draw the AutoShape by using the drawing toolbar. Then right-click on the shape, hyperlink, place in this document and choose your sheet.

A fancy way is to create a drop-down list with all the sheet names. Then use hyperlink( ) to link to the selected worksheet. Don't even need a combobox.

Hope this helps.

Epinn

"Anand vijay" wrote in message ...
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?

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?