Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |