Hyperlink Help

[Phill Palmer]

Good Day Ladies and Gents.

I have a workbook with multiple sheets, some hidden and some not. I'm using the bit of code to link to a hidden sheet within the work book

Please Login or Register  to view this content.

This works fine if I have created a hyperlink by using the menu "Insert" the "Hyperlink" buttons. Unfortunately in this sheet I create hyperlinks using the cell contents using this function

=IF(D8="KIT",HYPERLINK("#"&CELL("address",INDIRECT(B8&"!C5")),"Click To View"),"")

for some reason that I cant fathom these links wont work to the same sheets as the fixed hyperlinks.

Any Ideas ?

[Phill Palmer]

Hyperlinks.xlsm

Here is a sample sheet

[Phill Palmer]

Bump, Can anyone help ? or has this got us all stumped

[Phill Palmer]

Has anyone got any ideas please, or is what i'm trying to do not possible?

[soledad]

I think cells that get by HYPERLINK function is not true hyperlink target,then it could'nt work fine with your macro !
You can try attached file as below . Hope you finding best solution .

[Phill Palmer]

I think cells that get by HYPERLINK function is not true hyperlink target,then it could'nt work fine with your macro !
You can try attached file as below . Hope you finding best solution .

Thanks a lot for the reply, it works like a dream