Create Sheet Name Index and add Hyperlink

[wherdzik]

Can someone help me augment this code so that when this code spits out the sheet names it also creates a hyperlink to the sheet name?

Thank you for your time.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Logit]

.
Here's a different approach. The macro, placed in the first sheet (Index) will automatically create hyperlinks to all sheets
as they are created (or already exist at the beginning). As sheets are deleted so are the hyperlinks.

Please Login or Register  to view this content.

[wherdzik]

HI Logit,
Will this add only sheets that have an underscore. The only ones that I want to add is ones with this type of naming standard 105265_Smith...So a numeric value underscore followed by the last name. This is a very cool code. Can it be augmented for this type of naming standard?

[mjr veverka]

Please Login or Register  to view this content.

[wherdzik]

Oh wow...thank you guys for the multitude of resolutions.

I did manage to get Logits code to the way I needed to.

Please Login or Register  to view this content.

Thanks again guys. I hope this is okay the way I did it. It seems to work .

[wherdzik]

Is there a way to change Logits code so that it clears contents after row 3?
Thank you!!!!