Variable Hyperlink in VB

[russelldt]

Hello

I hope some genius out there can help me.

I have a cell in sheet 1(call it the source cell), hyperlinked to a hidden sheet. The text in the source cell and Sheet Name are the same, so when i select the cell, the hidden sheet opens. Here is the VB routine i am using:


Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Dim shtName As String
shtName = Target.Name

Sheets(shtName).Visible = xlSheetVisible
Sheets(shtName).Select
End Sub


I now have a dropdown menu in the source cell and I have to select different text depending on which sheet i want to access by the hyperlink. There is always a unique sheet for the different text options. I just can't get this to work.

Looking for help. please

Thanks

 

[Fluff]

I said

Best to start a new thread please.

 

[russelldt]

Ah, missed the second message, thanks. I have posted as a new thread.

 

[Fluff]

Thanks.

 

[russelldt]

Hello Fluff,

Its me again.

I now have to modify the scenario a bit.

The cells that previously had a drop down menu, are now updated (via a lookup function) based on a dropdown menu in another cell (k19).

So what happens is that the dropdown selection happens in K19, this creates 3 unique names in cells C15, D15 and E15 - based on what has been selected in cell K19. I woild then select the relevant cell to open the hidden sheet.

So the same end result, but i need to get there via different inputs.

Can you have a look and assist with a solution

Thanks

 

[Fluff]

As this is significantly different from your original question, it needs a new thread. Thanks

 

[russelldt]

As this is significantly different from your original question, it needs a new thread. Thanks

Ok Thanks

 

[russelldt]

Ah, I see the reasoning. No, A1 was just a reference. Its only C15, 16 and 17 at present. I will remove the reference to A1.

I will extend the functionality to other cells on the sheet in time

Hello Fluff, not sure if this is a new thread, but how do i automatically hide only the sheets that have been opened this way (none of the other open sheets).

Thanks

 

[Fluff]

Just put a hyperlink on the sheets back to the original sheet.
If you need help with it, please start a new thread.

 

[russelldt]

Just put a hyperlink on the sheets back to the original sheet.
If you need help with it, please start a new thread.

 

[russelldt]

Thanks again