Code to resize images maintaining ratio

Hi there.

I once had a macro which was built for me, that resized the width of an image to 11cm whilst maintaining the ratio of the height.

I am not very experienced at all in coding my own Macros. I have tried recording one to achieve this but the image never resizes the height correctly, it always resizes to the measurement of the picture that I resized whilst recording the macro.


Work have chucked away my old computer and I have lost all my lovely Macros

Can anyone help?