Copy sheet without copying buttons

Question

i am trying to make a character creator tool for a game. im almost done but i wanted to add a button the saves the character code looking like this

Sub Save_character()
Dim ws As Worksheet

Worksheets("character creator").Copy _
After:=ActiveWorkbook.Sheets("character creator")

Set ws = ActiveSheet

ws.Name = Range("b14")

End Sub

but i dont want this button to be added to the copied sheet. Any idea how i may do that?

thx in advence. a VBA/excel rookie

Answer 1

There's a setting for this:

Application.CopyObjectsWithCells = False
'copy your sheet
Application.CopyObjectsWithCells = True 'reset

Same as: Options >> Advanced >> Cut, Copy and Sort inserted objects with their parent cells (uncheck)

Answer 2

You can delete the button using

ws.Shapes("YourButtonName").Delete