VBA that will 'click' a dynamic link to another sheet

**samcdavies** · 08-21-2013, 06:31 AM

Apologies if I use the wrong wording here, but I have a dynamic hyperlink to one of 50 sheets in cell G5 - it changes depending on what is selected in G6. It looks like this;

Please Login or Register  to view this content.

I would like a piece of VBA code that, whenever G6 is changed, the hyperlink in G5 is 'clicked'.

Is this possible? I've searched all over the web and cannot find an answer. Thanks in advance.

**Norie** · 08-21-2013, 08:22 AM

Instead of using the hyperlink in G6 why not use code triggered by a change in G5?

That code could either hyperlink to the selected sheet using FollowHyperlink or goto the sheet using Application.Goto.

**samcdavies** · 08-21-2013, 08:26 AM

Originally Posted by Norie

Instead of using the hyperlink in G6 why not use code triggered by a change in G5?

That code could either hyperlink to the selected sheet using FollowHyperlink or goto the sheet using Application.Goto.

Thanks for that, that's a good idea, yes. The hyperlink would have to be dynamic, like it is in the cell. Do you know how I could structure that into VBA code?