Babydum
Board Regular
- Joined
- Feb 24, 2005
- Messages
- 164
Hi
I have a table of contents on a sheet that uses hyperlinks to open other sheets within the same workbook. If i change the sheet names, I have to manually fix the hyperlinks.
Can I get the hyperlink to behave in the same way as a formula in that it adjusts sheet names automatically when they change?
I have a table of contents on a sheet that uses hyperlinks to open other sheets within the same workbook. If i change the sheet names, I have to manually fix the hyperlinks.
Can I get the hyperlink to behave in the same way as a formula in that it adjusts sheet names automatically when they change?