Picture Aspect Ratio for Comments

Hello,

I have an existing spreadsheet that has nearly 150 comments that each contain a picture. Unfortunately when this was created the box for Lock Picture Aspect Ratio was not checked for each comment. Is there a way to run a macro that will check this box for all the comments on this page or do I need to manually go into each comment and check the box?

Thanks for your help!!
Jessica

Hi Jessica,

The following macro will 'Lock the Aspect Ratio' for all comments on all sheets in the Active workbook. After locking the 'Aspect Ratio', it didn't seem to have any effect on my pictures in Excel 2003.

Please Login or Register  to view this content.

Lewis