Hyperlink Activation

  • Thread starter Thread starter Frank T
  • Start date Start date
F

Frank T

I'm now using Excel 2002 and can not activate any of my
Excel 95 or 97 hyperlinks using the "enter" key, teh
clicking of the mouse works but I prefer to stay on the
keyboard if possible. Is there a setup some where that I
can go to?
 
I'm not sure you can. (I haven't been able to, anyway.)

Maybe you could use a macro and assign it to a nice short cut key:

Option Explicit
Sub followMyLink()

Dim myLink As String

If ActiveCell.Hyperlinks.Count > 0 Then
myLink = ActiveCell.Hyperlinks(1).Address
Else
myLink = ActiveCell.Value
End If

ThisWorkbook.FollowHyperlink myLink

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And to assign the shortcut key:

tools|macro|macros|Options button
choose a nice unused combination
click ok and then click cancel.

If you have a macro like this in your personal.xl* file in your XLStart folder,
it'll be available whenever you open excel.
 
Back
Top