How to follow hyperlink with keyboard?

[jaapvanharen]

Hello all

In a previous version of Excel (or with the help of an add-in or macro) it was possible to hit the ENTER key (after selection of a a cell that contains a hyperlink), on which Excel did follow that link (to a cell, sheet, file, internet, whatever).
I cannot find this "function" in Excel 2007, nor can I find add-ins or macro's that may be helpfull here.

Thanks,
Jaap

 

[RolfJ]

Try hitting the Application key (typically located to the right of the right Windows key). That should bring up the context menu from which you can select 'Open Hyperlink'. Please note though that I am writing from a laptop that doesn't have Excel2007...

 

[jaapvanharen]

Hi Rolf,

Thanks for your reply.
The menu you suggested does have a "follow link" option, but to select it I have to hit several keys in order to activate it:
- application key
- cursor up (2x)
- hit Enter

or

- application key
- "O" (2 times)
- hit Enter

In either case I have to hit 4 keys in stead of 1. This is an increase of 300%. And I'm just trying to get rid of my RSI ....)

I don't understand why MS has introduced this new "shortcut", do the have share in medical companies?

Anyway, thanks for the tip. This works indeed, but is not the solution I want to use extensively. I hope you (or others) can direct me tot the final solution: hitting just one key!

Greetings,
Jaap

 

[RolfJ]

Hi Jaap:

alternatively you could put the following code into a standard VBA module and then assign a shortcut key to it:

Sub FollowHyperlink()
    ActiveCell.Hyperlinks(1).Follow (True)
End Sub

Hope this helped.

 

[jaapvanharen]

Hi Rolf,

Maybe this can do the trick.
Just one trick: I'm a real novice on VB. I can make a macro when recording it, but only for the current worksheet.
If you can give me some hints to make this a generic macro, I would be very grateful.

Thanx,
Jaap

 

[jaapvanharen]

Hi Rolf,

After some troubles I managed to copy your lines into a sheet. And it WORKS! Thanx!

Only tow (minor) issues:

1) I cannot use this macro unless the sheet containing it is open, I do need to copy it to other sheets to open it. Don't think this is wise, but how to make this macro a generic one?

2) Normaly I work with my sheets in maximized mode. After applying the macro, all sheets are in "restored size". Any thought on that?

Hope to hear from you,

Greetings,
Jaap

 

[mahlholm]

Hi,

If you want to make a macro available for all workbooks you need to create a 'Personal Macro Workbook'. The easiest way to do this is to record a new macro and chose to store the recorded macro in 'Personal Macro Workbook'. After you stopped the recording excel have now automatically stored your personal macro workbook, which will be opened everytime you start excel.