In Excel 2003 there is a buttom within the format picture dialog to
compress pictures in the document. I would like to automate this step
with a macro. I used the macro recorder when performing this action
and it does not seem to record and information about compression. Is
there a way to compress all pictures in the document with a macro?

Thanks,