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?