Compressing Pictures in Excel
 

In the "Format Picture" menu of Excel there is an option to compress all the
images in the workbook. This is great and turned my 18MB book to 6MB. I want
to put a button on my custom toolbar to do this in one click. I cannot find
the methods (?) for compression listed in the help. Also, how do I select all
pictures in the workbook without looping through each sheet? Can anyone help?