Create shortcut to open a link to a website?

[badbeat1]

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!

[PaulSP8]

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.

[badbeat1]

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.

[PaulSP8]

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?

[badbeat1]

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.

[PaulSP8]

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 <

[badbeat1]

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.

[PaulSP8]

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

Thanks.

[badbeat1]

I've attached an example.

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

[PaulSP8]

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

[badbeat1]

It worked exactly as it should!

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

[badbeat1]

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?

[PaulSP8]

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.

[badbeat1]

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?

[PaulSP8]

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.

[badbeat1]

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