Resizing an image to a % value

[Taff]

It would appear that I cant actually resize an image to a % value. Below is a macro I recorded, would it be possible to set it to a % value, possibly by gaining the initial width and then working out the % from the final width so that I can apply a similar scale to other images?

Please Login or Register  to view this content.

Thanks for any help.

Taff

[Leith Ross]

Hello Taff,

Here is some information on the Scale Height/Width Method that should help you.

Scale Height/Width Method
Scales the height or width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original size or relative to the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height.

Syntax

expression.ScaleHeight(Factor, RelativeToOriginalSize, fScale)
expression.ScaleWidth(Factor, RelativeToOriginalSize, fScale)

expression Required. An expression that returns a Shape or ShapeRange object.

Factor Required Single. Specifies the ratio between the height of the shape after you resize it and the current or original height. For example, to make a rectangle 50 percent larger, specify 1.5 for this argument.

RelativeToOriginalSize Required Long. True to scale the shape relative to its original size. False to scale it relative to its current size. You can specify True for this argument only if the specified shape is a picture or an OLE object.

fScale Optional Long. Specifies which part of the shape retains its position when the shape is scaled. Can be one of the following MsoScaleFrom constants: msoScaleFromBottomRight, msoScaleFromMiddle, or msoScaleFromTopLeft. The default value is msoScaleFromTopLeft.

Sincerely,
Leith Ross

[Taff]

Leith,

looks like you've saved me again, thats a lot better than my complicated solution.

Cheers,

Taff