Create shortcut to open a link to a website?

Hi,

I have an Excel document where I open a lot of link to websites. Right now I have to click on each link in each cell to open the websites they're directing to. But it would be much easier, if I just had a shortcut for this rather than have to click on the cell.

Unfortunately, I have not really been able to figure out how to do this. I'm using Excel 2016 for Mac.

Thanks!

Not sure if I've understood correctly, but I imagine you to have links to websites set up in different cells?

You can use a Macro to follow them all in one go, like;

Please Login or Register  to view this content.

Amend the Ranges to suit.

Or, if you've get them all lined up in a column you could do it like this;

Please Login or Register  to view this content.

If that's not what you wanted then post back with more details.

That's correct.

But it is only the link(s) of the cell(s) I'm currently on or marking I would like to open. Typically, it just the link of the cell I'm currently on, I would like to open.

I'm sorry I don't understand what advantage a "shortcut" would have over a hyperlink in that case?

Am I missing something?

Perhaps if you could upload a sample workbook (instructions on the Yellow Banner above) it would help to see what you're trying to achieve?

Instead of having to click on the cell with the mouse to open the link, I can just navigate to the cell using the keyboard, and then with a keyboard shortcut, I can open the link.

Ah! - OK - So, use this code...

Please Login or Register  to view this content.

Then use the Developer > Macros menu and select the Macro from the list, on the right hand side you'll see "Options" - Click on that and it'll allow you to assign a keyboard shortcut to that Macro, pick your key that you'd like to use and you should be good to go

If you need more help then see > https://support.office.com/en-gb/art...2-1b5e8e81d96a <

Thanks a lot. Didn't work, but I think that's because I have not stated the scenario properly.

Each cell has a name, and that name then has a link, if that make sense? So I can have a cell named "cell1". "cell1" has a link to excelforum.com eg.

Can you upload an example in an Excel file attachment so we can see exactly what you are dealing with please?

Thanks.

I've attached an example.

Each cell has some text, but also a link attached. I want to open the link.

Right. This is a weird one.

I took a look at your Workbook and couldn't get anything to work, I kept getting Errors when trying to open the Hyperlink and I couldn't work out why.

Then I tried to actually click on your link, and I got the exact same error message when trying to open the link as when I was trying to do it in VBA.

So, I added some of mine and they all worked perfectly when I clicked on them and when I used VBA.

In short - I'm stumped.

Research suggests that the URL can't be longer than 255 characters (which none are), it also suggests there are registry fixes for the problem on a Windows machine (which won't help you). It could also be something to do with this site blocking certain things from happening as I couldn get the same links to work in a new Workbook when I tried to recreate what you'd done after seeing it work on my selected links.

So, much as I hate to admit defeat I'm clueless at this point

I've attached what I've done so you can see if you can it to work for you - I've added a Google link and a few Amazon links and they all work if you go to the cell and press CTRL & M (You'll need to change this to whatever works on a Mac (Option & Cmd at a guess).

The code is simply;

Please Login or Register  to view this content.

Hopefully it'll work with your real world need

It worked exactly as it should!

Thank you very, very much for taking the time to help me. Have a nice day!

Another question actually:

Normally, when you click a link, it changes color from blue to purple. When using shortcut, it does not change color.

Is it possible to do this behaviour still even though we use the shortcut?

Really glad to hear it's working, was properly confusing me at first :-/

Yeah, you can change the colour - But it'll be a permanent change;

Please Login or Register  to view this content.

Just me that's bad at explaining it.

Thanks again, but there isn't anyway to get the exact same behaviour, so it doesn't stay permanent?

No - I knew what you meant - I hadn't realised that they weren't changing colour actually.

Unfortunately I can't seem to see a way to make them do it either, sorry.

No problem, and once again, thank you very much!