Compress All Pictures in Excel Workbook

[Rohmeo]

Hi

I'm attempting to shrink some excel workbooks with lots of graphics inside.
I have found the menu options of 'Picture Tools' > 'Format' > 'Compress Pictures' function to be very useful in achieving this.

Going through each individual pictures on each sheet and across many workbooks will be very time consuming.
Is there a way to compress all pictures (with or without VBA Code) at once?

Thanks

 

[Haluk]

Hi;

Uncheck the option "Apply only to this picture" to compress all the pictures.