Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Rotation property?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Rotation property?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie Chart - Rotation Sean Charts and Charting in Excel 0 March 17th 10 01:31 PM
Text Box Rotation Garyw Excel Discussion (Misc queries) 11 February 9th 10 04:09 AM
Job Rotation app? PPM at Brackmills Excel Discussion (Misc queries) 1 June 10th 09 12:54 AM
Chart Rotation GatorGirl Charts and Charting in Excel 8 March 20th 07 01:46 AM
Runtime error 380: Could not set the List property. invalid property value of listbox jasgrand Excel Programming 0 October 6th 04 09:28 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"