Hi,

Could someone help me with a macro to change the size of an inserted picture based upon a cell value. I have a sheet called 'Front Page' with 3 pictures inserted on the page. If the value in cell E18 is greater than 0 then the I need the bottom picture on the 'Front Page' to shrink from Height - 3cm / Width 7.02cm to 0cm / 0cm.

So basically the picture cannot be seen if cell E18 have a value of 0. Any other value in this cell would mean that the picture is the orignal size.

Thanks

Jon