2010 Word - Resize picture macro

statics

New Member
Joined
Jul 19, 2012
Messages
1
Hello all,

I have used this website in the past for numerous tips and tricks with excel VBA.

I am having a few issues with 2010 word, and have never written a macro in word 2010 before so I am having some difficulties.

Anyway, I am looking for a way to essentially program a button to automatically re-size a picture. I import a lot of pictures into a word template, crop them, re-size them by dragging the corner to keep the aspect ratio locked. I am looking for a way to speed up this process as it is time consuming and tedious.

I have tried numerous code snippits but either none of them have worked in word 2010, or I am doing something wrong setting up the macro.

Any advise or assistance will be greatly appreciated.

Thank you,
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
A macro is unlikely to make this any faster than it can be done manually, especially if the pictures have different final sizes.

If the pictures need to be constrained to a consistent maximum width and/or height, the quickest way of achieving that end is to create a table with fixed-size cells of that size. Word will automatically fit any picture you insert into the cell to the cell's size, maintaining the original aspect ratio. Even if you then want to put the pictures somewhere else in the document, it becomes a simple matter of moving them from the cell to the new location - no resizing will occur.
 
Upvote 0

Forum statistics

Threads
1,225,624
Messages
6,186,068
Members
453,336
Latest member
Excelnoob223

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top