Hi everyone,

I would need to ask for your kind help regarding a shape related macro issue I am facing.
In my task, I would need to copy a shape and some numbers in different cells inside the shape from one worksheet to another by clicking a button. The shape is overlapping the whole range of cells with the numbers. I would then click the cells inside the shapes to change the values in each of them to perform some further calculation without changing or moving the shape that is on top of the cells.
Now the problem I am facing is, every time I click the cells inside the shape, the shape is always selected but not the cells. I need to select a cell outside the shape and then use the cursor to select the cells inside. I tried to "sendtoback" but that didn't solve the problem either.
Could you please help me solve the issue by making the shape un-selectable or like a watermark in the background, that cannot be selected (but could be deleted when necessary) and the text/numbers inside the shape can be selected without any issue.
Please see below my codes. Many many thanks for your help.
Regards
Zamiur

Sub Input_Selection()
Dim s As Shape
For Each s In ActiveSheet.Shapes
If Not Intersect(Range("A8:Z100"), s.TopLeftCell) Is Nothing Then
s.Delete
End If
Next s
‘Copy Cells from Worksheet 11
Worksheets("Sheet11").Range("A2:Z100").Copy
Sheet1.Range("A2").PasteSpecial
‘Copy Shapes from Worksheet 11
Worksheets("Sheet11").Shapes(2).Copy
Sheet1.Range("B11").PasteSpecial

End Sub