is there a property instead of ScaleWidth method

E

EXCEL$B!!(BNEWS

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
 
P

Peter T

You can only get back to the original size with Picture objects and
oleObjects

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a variable in a ShapeRange.Increment 0
Resize commentbox in VB 1
Insert Picture using Macro 10
Launching PowerPoint from an Excel application 2
Rescaling a Comment text-box 3
change size of object 1
Control the size of a Comment Box in Excel 2007 from Access 2007 1
Macro for variable picture 1

Top