Creating hyperlink automatically from cell to sheet

Hello guys,

I have created alot of sheets based on cell values. Now I want to automatically create hyperlinks in the cells that directs me to the sheet with the same name.

Does anyone in here have a script for this, or anything that can point me in the rigth direction? I am new to VBA, but it is superuseful in my daily worklife.

Best regards
Jan Inge

Please Login or Register  to view this content.

I attached a sample file. Only thing is that a worksheet with name "Content" must be available (or change name)

This works absolutely great, thank you .

I have two more questions if it is ok for you:

1. Is there anyway to edit this so it only makes hyperlink from cell A6-A999, instead of deleting all other info in sheet?
2. Is it possible to run this all the time, so when you add a new sheet or cell is comes up automatically?

Again, thank you.

//JIO

of course
1) from A6 down, so there is data above which should not be erased, but why limited to A999? Is there data below? if not then I would propose to delete everything down from A6.
- above A6 is data and no hyperlinks to sheets? --> then the destination address has to be change to "A6"

Please Login or Register  to view this content.

2) there is a workbook event that can trigger the macro

Please Login or Register  to view this content.

But if you afterwards rename a worksheet then you have to trigger it manually.

I have found something on the internet but this means you have to add the class to the workbook and additionally the function Worksheet_Activate() on every sheet
https://stackoverflow.com/questions/...event-in-excel