how to crop a picture with VBA so that the cropped area does not remain in memory

If you crop a picture in excel, the edges, even though cropped, are always there (just not visible when the crop command is not on) and take up extra memory so excel has a command to trim these: Select picture > Format Tab > Compress Pictures (on the upper left) > Delete cropped areas of pictures > OK. Rather than doing this manually, is there a way to do this with VB? I tried recording the macro while doing the sequence above, but the code does not show up.

Thanks

Anyone?...

Press F5 =>Special Cells=> Objects => OK
This will select all the objects on the worksheet.
or

Please Login or Register  to view this content.

I have not seen the code for compressing pictures from the Picture Ribbon.
Possibly a SendKeys command would be required.