stafire_18
Board Regular
- Joined
- Dec 8, 2004
- Messages
- 162
is there anyway i can create a macro to move a drawing object like an inserted line back to a default location if it is ever moved?
With Sheet1.Shapes("Line 1")
If .Left <> 10 Or .Top <> 10 Then
.Left = 10
.Top = 10
End If
End With
With Sheet1.Shapes("Group 3")
If .Left <> 10 Or .Top <> 10 Then
.Left = 10
.Top = 10
End If
End With