Hyperlink button

[saadferoze]

Dear Members,


I would like to have button on each of my worksheet which takes me to the index page of the model. what kind of coding do i need to do for this.


Regards

Saad

 

[Luke M]

This is probably the fastest/easiest way to create hyperlinks:

http://blog.contextures.com/archives/2009/11/04/creating-excel-hyperlinks-is-a-drag/

If you really want a button, the macro would be something like:

[pre]

Sub GetMeHome()
Worksheets("Index Page").Select
End Sub

[/pre]

 

[NARAYANK991]

Hi ,


Wouldn't it be easier to assign a short cut key , so that pressing the key combination does what you want ? You don't need to insert a button on each sheet ; thus if you assign the short cut key F to Luke's macro , then pressing CTRL SHIFT F will take you to the Index page.


Unless by worksheet , you actually mean workbook ?


Narayan

 

[saadferoze]

Thanks guys for the advice .. i will use it while creating the hyperlinks