Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a 500+ page document with a lot of images. I need to convert all of these to grayscale and to increase sharpness by 40%. Both of these tasks can be done by right clicking each image and choosing 'format picture'. However because there are so many images I wish to use a macro. I am using word 2010.

I am able to convert all images to grayscale. However I am not able to sharpen them since I do not know the required command/keyword. The macro recorder does not record anything you do int the 'format picture' dialog box so it is of no help. Do any of you know the command?

Here is my working code so far that converts all images to grayscale.

Sub Macro1()

'
' Macro1 Macro
'
'

Dim Pic As InlineShape

For Each Pic In ActiveDocument.InlineShapes

    Pic.PictureFormat.ColorType = msoPictureGrayscale

Next

End Sub
share|improve this question
1  
In general if you use the toolbar buttons the actions will be recorded by the macro. So select a picture, start the recording then adjust the image. – Brian Aug 1 '11 at 22:19
Hi Brian. Thanks for your response. However in word 2010 the macro recorder appears to be quite useless. The only thing it records are cursor movements by the looks of it. So for example I start the recorder, move my cursor to the image using arrow keys, and then use the 'format' tool in the ribbon (which is available when an image is selected). I then click 'Corrections' and click 'sharpen 25%'. Unfortunately none of this gets recorded in the recorder. I have little previous experience with macro recorder but it only seems to record the most rudimentary of tasks. Does it work on your system? – Gary Aug 2 '11 at 6:34

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.