The macro should not be in the sheet, but in the module. And no matter how many times you copy over a sheet, the macro will always remain that single one in the module. It's just that the button in each of the sheets will be assigned that macro.