An issue with setting up hyperlinks within the workbook

[jmac1947]

Hello.

I am trying to create a hyperlink (haveing never done this in code before) between a cell in a summary tab to the actual tab in the workbook that has the same name.

The following code executes and seems to work, that is the colour of the data in summary cell changes to hyperlink "blue" but when i attempt to execute the hyperlink by clicking in the cell i get a "Reference is not valid" error.

If I right click on the offending cell and select the same page (edit hyperlink) the it works just fine.

It is probably something simple, that is what normally trips me up

jmac

Please Login or Register  to view this content.

[millz]

hyper_link_data is a variable, so you need to change to this. This is with me assuming that's the worksheet's name.

Please Login or Register  to view this content.

[jmac1947]

thanks Millz,

a random test of one out of one shows that it now works, much appreciated, and thanks for the very speedy response

Jmac

[jmac1947]

Sorry Millz,

further testing shows it didnt actually do what i wanted and the error continues

hyper_link_data is actually a variable that contains the name of a tab in the current workbook, I am trying to set up links within the current workbook

Jmac

[millz]

That's weird because I just did something like that/similar and it works for me.

Try changing to

Please Login or Register  to view this content.

This was what I just did. I have several cells containing sheet names, selected the cells and ran this macro.

Please Login or Register  to view this content.

[jmac1947]

tarantulas latest working-saved.xlsm
Hi again Millz,

Slowly, well actually very rapidly, going crazy.

I changed my code in the create macro to use the first snippet from your last post and that seems to work OK.

As I already have a spreadsheet with some 60+ tabs i didnt want to recreate the tabs just to get the hyperlinks so I tried to create a simple "one time" hyperlink create macro.

In this macro I used the following code which should have done what I want, I get blue text underlined so it looks like hyperlink, error when i try to follow link

I will add the spreadsheet as well

Please Login or Register  to view this content.

[millz]

I get why now. It's because of the names, they need to be covered in ' '

Please Login or Register  to view this content.

[jmac1947]

Thanks millz,

that seems to work a treat (and I learnt some new stuff as well, double bonus

jmac

[jmac1947]

Thanks millz,

that seems to work a treat (and I learnt some new stuff as well, double bonus)

jmac

[jmac1947]

and I have no idea why that reply posted twice???