I have a button that calls a macro stored on a worksheet, so that when the
sheet is copied, the macro is copied with it. However, each time the sheet
is copied, the button in the new sheet retains a reference to the macro in
the old workbook. I have to manually right click on the button - Assign
Macro - Repoint to macro in current sheet. Is there a way to set up the
button so that it simply calls the macro stored in its parent sheet object
and not the workbook from which it was copied?

Thank-you