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.
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".
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.