View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCEL NEWS EXCEL NEWS is offline
external usenet poster
 
Posts: 43
Default is there a property instead of ScaleWidth method

hi,
when i use ScaleWidth method like these

ActiveSheet.Shapes("Object 8").Select
Selection.ShapeRange.ScaleWidth 0.48, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.48, msoFalse, msoScaleFromTopLeft

i can make the shape smaller,

but how i can get the scale which has been "ScaleWidth"ed ,

is there a property instead of method

thanks