How to Copy a Master worksheet that contains Buttons with Macros Assigned

If you are using Form-type buttons and use the Worksheet.Copy method to copy the sheet, it could work.

Show your code that copies the Master sheet and what type of buttons are you using?

AlphaFrog, my code is below. I think it might have something to do with the Buttons.Add lines but im not quite sure, only do the basics

Cheers

Sub Create_New_Employee()
'
' Create_New_Employee Macro
'

'
Sheets("Master").Select
ActiveSheet.Buttons.Add(5.25, 6.75, 261.75, 33.75).Select
ActiveSheet.Buttons.Add(446.25, 4.5, 261.75, 33.75).Select
ActiveSheet.Buttons.Add(285, 4.5, 141.75, 33.75).Select
Sheets("Master").Copy After:=Sheets(2)
Sheets("Master (2)").Select
Sheets("Master (2)").Name = "New Employee"
Range("D5").Select
End Sub

In your code, after creating the copy and naming it, try inserting...

Sheets("New Employee").Shapes.SelectAll
Selection.Delete

Of course this assumes you no longer want the buttons. Otherwise one method is to retrieve button names and reassign their respective macros.

If the Master Sheet already has the Buttons with assigned macros, this will copy the sheet with the buttons.

Sub Create_New_Employee()
'
' Create_New_Employee Macro
'
    Sheets("Master").Copy After:=Sheets(Sheets(Sheets.Count))
    ActiveSheet.Name = "New Employee"
    Range("D5").Select
End Sub