Hi Everyone,

I've posted this question before but had no response, so I have reworded it and I’m showing my current code:

I have a worksheet with a command button on, that once pressed moves to the next tab in the workbook. It also resizes the new tab to fit the screen size of the users computer. As below: 

Please Login or Register  to view this content.
The problem I’m having is that on the new tab are pictures, in Excel 2003 these automatically resized with the rest of the tab. However I have now been upgraded to Excel 2010 and this no longer happens, meaning all of the formatting on my new tab is messed up.

Is there any way to alter the code above so it will also resize the pictures as well as the rest of the tab?

Thanks for any help in advance

Kind Regards
E