VBA Hyperlinking to user input worksheet

[kys2000]

Hello,
I have a macro that creates a new worksheet based off of a user input held in the variable userworksheet (DIM userworksheet as string). For example: the user inputs worksheet1 and then a new sheet is created with that name. So I need the VBA command that will create a hyperlink in the active cell of another worksheet using the variable userworksheet.

Can anybody help?

[JBeaucaire]

Here's a macro showing how to create a "table of contents" of hyperlinks for all the worksheets in a workbook.

Hyperlink Sheets

The syntax you see here should give you what you need to tweak your existing macro to utilize your variable to add a hyperlink in the same manner.

[kys2000]

Here's a macro showing how to create a "table of contents" of hyperlinks for all the worksheets in a workbook.

Hyperlink Sheets

The syntax you see here should give you want you need to tweak your existing macro to utilize your variable to add a hyperlink in the same manner.

Perfect!! Thank you.