Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Shape1 is 2 inserted BMPs grouped then named.
The shape group "Shape1" still has the green dot that allows manually setting the rotation. (unlike what happens when grouping a bitmap and a textbox)... that resulting group of shapes has a disabled rotation feature. ActiveSheet.Shapes("Shape1").Select Selection.ShapeRange.IncrementRotation 270 Selection.ShapeRange.Rotation 120 Object doesn't support this property or method. on the 3rd line; why does line 2 work and not line3? Is there some alternate way to set the rotation? -- Regards, John |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi John,
Change: Selection.ShapeRange.Rotation 120 to Selection.ShapeRange.Rotation = 120 --- Regards, Norman "John Keith" wrote in message ... Shape1 is 2 inserted BMPs grouped then named. The shape group "Shape1" still has the green dot that allows manually setting the rotation. (unlike what happens when grouping a bitmap and a textbox)... that resulting group of shapes has a disabled rotation feature. ActiveSheet.Shapes("Shape1").Select Selection.ShapeRange.IncrementRotation 270 Selection.ShapeRange.Rotation 120 Object doesn't support this property or method. on the 3rd line; why does line 2 work and not line3? Is there some alternate way to set the rotation? -- Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pie Chart - Rotation | Charts and Charting in Excel | |||
Text Box Rotation | Excel Discussion (Misc queries) | |||
Job Rotation app? | Excel Discussion (Misc queries) | |||
Chart Rotation | Charts and Charting in Excel | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming |