Copy sheets with buttons to new workbook

[MattCSI]

Hello everyone. I'm a new user, so I hope this is the right sub-forum.

How do I make a button look for the specified macro within the current workbook, rather than looking back to the workbook the sheet was copied from?

Background:
I have a master workbook containing template worksheets. The template worksheets have buttons linked to macros in the workbook modules.

Users copy the master workbook to multiple folders across the server. They also make multiple copies of the template worksheets within their new copy of the workbook. Everything seems fine up to this point.

The problem arises when users copy a sheet from one workbook to another. The named ranges are set up to allow this without creating external links, but the buttons are not. The buttons remain linked to the macro in the workbook the sheet was copied from.

This becomes very problematic as files are moved and archived. I can’t restrict users from copying sheets between workbooks, so I’m hoping there’s a way to fix the buttons so they don’t look for external references.

Any ideas?

[AlphaFrog]

Use ActiveX-type command buttons instead of the Form-type buttons. They don's have this issue because their code is in their worksheet's code module which is copied with the sheet.

[MattCSI]

Thank you! That's very good to know.