Andrew Davis
asked on
Excel 2010 edit Hyperlink when sheet copied.
Pre-amble:-
I have a sheet that has a macro to create a copy of it.
The sheet has hyperlinks that link to various cells within the same sheet.
Problem:-
When the sheet is copied the hyperlinks in "CopySheet" still link back to the cells in "OrigSheet".
From what i can tell this is stored in SubAddress but i cant see how i can change all hyperlinks on the "CopySheet".
Any assistance greatly appreciated.
Cheers
Andrew
I have a sheet that has a macro to create a copy of it.
The sheet has hyperlinks that link to various cells within the same sheet.
Problem:-
When the sheet is copied the hyperlinks in "CopySheet" still link back to the cells in "OrigSheet".
From what i can tell this is stored in SubAddress but i cant see how i can change all hyperlinks on the "CopySheet".
Any assistance greatly appreciated.
Cheers
Andrew
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.