Automation of Hyperlinks among many worksheets

[srinivasan1965]

Hi all

With the help of forum I was able to create multisheets through macro based on the file name entered in list sheet.

I request for a macro for auto hyperlinks for getting in to to work sheets.

can it be added in the same macro.

sample file is attached.(Multisheet mahidhara)

Thanks & Regards
N.Srinivasan

[stojko89]

Right Click sheet List / View Code / And Copy this code:

Please Login or Register  to view this content.

I hope I understood what you needed

[srinivasan1965]

Hi
I have copied this code.It shows some error.(procedure error)I am not sure if if have explained my requirement properly.
When we have 50 or 100 sheets. It is very difficult to give hyperlink reference for each and every sheet.
If we A1 common cell reference for each and every sheet if a macro code will help when you click the first item it will take us the relevant page and when you click second item it will take us to A1 cell of the second sheet and so on.

Thanks & Regards

[stojko89]

You're missing this part of the code:

Please Login or Register  to view this content.

[stojko89]

This is a "hyperlink" when you click on a value in column A it activates the sheet with the cell name u clicked.
To make a hyperlink to go back to "list" sheets then you'll need to insert something in the create sheet macro

[stojko89]

Try this out.
When you enter a name in column A a sheet will be created with the template.
Each sheet that is created has HOME writen in the A1 cell.
When you click the A1 cell you will get back to sheet "list"
In case you're making a sheet with the same name as the one before you will get a msgbox that the name already exists and that you should pick a different name.

Try the workbook out and let me know if you want to do anything different.

[srinivasan1965]

Hi
It is really superb. It is working fine.

Thanks a lot
Regards
N.Srinivasan