VBA Macro to autosize Comment with picture

[Tdeulkar]

Hi

I am not a developer so please excuse me if I am asking basic questions here.

I am working on a large excel which has comments with text as well as some comments where I only have pictures.

I followed the guideline and created a Macro which autosized all the comments with text correctly. But the comments with only pictures are at its minimum dimension ( I can not see anything for these comments)

Can you help me with a code to autosize all the comments with text, as well as comments with pictures only?

Thanks in advance
Trupti

 

[Domenic]

It looks like AutoSize reduces its size to a minimum. So I think you'll probably need to set the width and height properties of the shape object for the comment instead.