Hello,
The code below has been implemented to:
1. delete existing OLE shapes from hidden worksheet 1
2. copy new OLE shapes from hidden worksheet 2
3. paste the copied shapes in hidden worksheet 1
The command button is on a worksheet 3, which is the only visible sheet to the user.
The code works fine for steps 1 and 2, but doesn't work for step 3 (pasting the shapes to hidden worksheet 1).
The code is as follows:
Private Sub CommandButton1_Click()
ThisWorkbook.Worksheets("6").Shapes.Range(Array("1", "2", "3", "4", "5")).Delete
ThisWorkbook.Worksheets("7").Shapes.Range(Array("1", "2", "3", "4", "5")).Select
Selection.Copy
ThisWorkbook.Worksheets("6").Select
Selection.Paste
End Sub
The answer appears so close - all help appreciated.
Selection.Paste
by this
Selection.PasteSpecial
gowflow