I have a form in Excel with shapes, check boxes and text boxes. I created a macro so users can duplicate the tab and the locked cells are unlocked. But the below macro is copying and pasting 2 of the shapes, check boxes and text boxes.
How can I get it to just copy the form as is without doubling the shapes, check boxes and text boxes?
Sub blank_custom()
ActiveSheet.Copy After:=Sheets(Sheets.Count)
ActiveSheet.Unprotect Password:=6291
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = True
End Sub
Bookmarks