I looked around. All I was able to find was resizing in Excel or through Excel.
I am pasting a picture from pdf and need one click resizing and positioning.
To resize a picture, on the Picture Tools Format tab, in the Size group, enter the new measurements into the Height and Width boxes. To resize a shape or other object, on the Drawing Tools Format tab, in the Size group, enter the measurements you want into the Height and Width boxes.
Right-click the object. On the shortcut menu, click Format<object type>. In the dialog box, click the Size tab. Under Scale, enter the percentage of the original height or width you want the object resized to.
I finally got it .. Here is what I did, just in case someone is facing same problem. This re-sizes the image, sets it in the desired position and sends it to the back.
Sub Resize()
With ActiveWindow.Selection.ShapeRange
.Height = 2.78 * 72 //72 is the multiplier for the inch
.Width = 4.17 * 72
.Left = 0.78 * 72
.Top = 1.25 * 72
.ZOrder msoSendToBack // This sends picture to the back
End With
End Sub
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With