View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkBradshaw MarkBradshaw is offline
external usenet poster
 
Posts: 7
Default VBA in Excel 2003

I am trying to write a small little macro in VBA that upon clicking a button
resizes,
moves and rotates a picture or autoshape on the active sheet.

I have found; .Left .Top .Height .Width properties without problem but after
30mins searching I still am at a loss as to how programmatically to rotate an
object.

I.e. for the sake of an easy example using defined numbers:

With ActiveSheet.DrawingObjects("AutoShape 10")
.Left = 200
.Top = 200
.Width = 50
.Height = 50
End With

How do i rotate the autoshape? .Rotate or .Angle would make sense but
apparently
don't exist...

Thanks in advance,

Mark