Copying controls from Excel Sheet
I am facing some problem in copying controls on excel sheet.
I have used
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
This function copy only the content and not the controls.
I don't wanna use copy method because it copies the entire sheet with formulae, image and button.
Please suggest me some alternative.