Looking for a VBA code that will allow a page to be duplicated to another all while keeping the shape sheet formulas.
I have a dynamic graphics template on one page that is adjustable via imputes from a data page. When I copy the template and paste to a new page
all the shape sheet formulas and relationships are gone. The formulas are still there in the shape sheet but all the references to that data page are gone.
Trying to prevent having to copy all the shape sheet formulas for the original page to the duplicated page. This would take far too long.
thoughts?
Not sure about relationships, but I have used the visio Selection object copy then paste method to paste shapes to a new page (copying over template objects to a new page), and the formulas seem to carry over.