I am working on an Employee Review form for each of our employees. I started with a Master sheet and come up with a VBA code that will create and name a new tab for each employee from the Master sheet. In addition, there is a VBA code assigned to a button on each sheet that will name and save a single sheet to a specific location based on the name of the employee on the tab. The problem is when I run the code to create the new tabs from the Master sheet, the macro button from each sheet/tab is still linked to the Master sheet as opposed to each employee’s sheet macro.

Is there a way to create the new sheets and have the sheet macro buttons look at each sheets macro as opposed to it looking at the Master sheet?

Thank you for any help with this matter.