Hi Jo,

It looks like MS forgot to implement the VBA side of this new feature.
Pretty lame hey ?

Best I could do was,
SendKeys "%oi%m%a~~{esc}"


Regards,
Vic Eldridge

"jo" wrote:

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,