Hello everyone!
I need help to solve this little problem that I have.
I need a macro that runs when abandoning one sheet. The problem is that this macro refers to shapes or objects that are not on the activate sheet, and an error occured. anyone can help me? Thank You!
I show below code
Private Sub Worksheet_deactivate()
Application.Goto (ActiveWorkbook.Sheets("G.3 damages").Select
If Range("AA48").Value = "eyes" Then
ActiveSheet.Shapes.Range(Array("72 Oval")).Select
Selection.ShapeRange.IncrementLeft -1939.7726771654
Selection.ShapeRange.IncrementTop 38.5227559055
End If
End Sub
Thanks!
Bookmarks