Shape "handle" location

  • Thread starter Thread starter David Cuthill
  • Start date Start date
D

David Cuthill

I have a small macro I have written the rotates a shape
based on the value of a cell on the worksheet. It works as
I want it to but something happens to the shape that
changes the location of the top of the shape to be 90
degrees offset (the green reference dot indicating the top
of the shape mysteriously moves to the side of the shape).
 
Sorry for the double post - I must have happy fingers as I
had intended to post my code as well.

This code runs everytime an entry is made in cells c15 or
c16.

ActiveSheet.Shapes("Picture 13").Select
With Selection
.ShapeRange.Rotation = False
.ShapeRange.IncrementRotation Worksheets("Sheet1").Range
_("C17").Value
End With

This seems to perform what I want it to do but its as if
the sheet forgets what the top of the image is when I
leave the sheet.
 
Back
Top