Text to Hyperlink.

[skyping]

Need some help chaps.....

I have a long column of text (starting at b3), which equate to the Worksheet names of the Workbook.

Is there any method (triggered by a macro), that can hyper-link each of these to the corresponding Worksheet?

Thanks for looking!

[grizzly6969]

not sure about a Macros but if you dont have alot of text you can remove for example sheet2 from your string and insert a text box here
put text in sheet2 / format text box with no color and no lines now hyperlink to sheet2 it will act like a hyperlink
If needed make fonts Blue to look like a linked word