"reset" pictures programatically

[twilsonco]

Hey guys,

I've got a workbook that runs on mac and pc. One of the problems with this is that pictures added in one platform lose their aspect ratio when opened on the other.

This can be fixed by using the "reset" button in the "format pictures" tab on the ribbon, but I don't know how to do that with vba. I gave up trying to compress pictures with vba, and this is another ribbon object so I don't know if this is possible.

The other alternative is to tag each picture so I know which platform is was imported in, that way I can check and resize when the workbook is opened in the other platform (the aspect ratio of a picture imported in windows and then opened in mac increases by a factor of ~1.226, so I can resize them again).

Another alternative is one that I don't know about that you awesome people can teach me! I like that one, or being able to access the "reset" button in the "format pictures" tab on the ribbon.

Thanks,

Tim



******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>