Resizing shapes with VBA 2003

[gm13958]

I work with excel and vba 2010.

To resize an image I use the following code

Please Login or Register  to view this content.

The first statement reduces the image size to 4% of its original size, while the second one restore the image to its original size.

This code works with vba 2010 and 2007.

Under excel 2003 it is executed but nothing happens.

I haven't excel 2003. Is there anybody who can help me?

[Leith Ross]

Hello gm13958,

The syntax is almost the same. In Excel 2003 you need to qualify the selection with the word Application. Unless you are changing only the scale of the height, you should also include the width. Also, only if the selection is either a picture or an OLE object can you specify the second argument (RelativetoOriginalSize) as msoTrue.

Please Login or Register  to view this content.

[gm13958]

Thank you very much. it works!