Following from last link - I have just thought of a workaround - but also there is a problem. If when the sheets are created they are all given the same name say sheet1 and a hyperlink created to this page but before the program loops the sheet is renamed to the name I want how do I update the hyperlink to account for the change in name?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel hyperlinks 2
- Thread starter andrew299
- Start date
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
