whazzzzzupp17
New Member
- Joined
- Jul 23, 2018
- Messages
- 21
I have an issues I have never been able to fix. I have a code that copies many sheets to a new master workbook and then renames the sheets on the master file.
However, all the hyperlinks from the sheets copied over no longer work, because the page name has changed. How can I go about renaming the hyperlink string for the page name?
However, all the hyperlinks from the sheets copied over no longer work, because the page name has changed. How can I go about renaming the hyperlink string for the page name?
VBA Code:
Sub RenameHyperlinks()
Dim i as Long
Dim SheetCount as Long
Dim ws as worksheet
SheetCount = Sheets.Count
i=11 'since I have 10 fix sheets and I add sheets after 10
For ws = i to SheetCount