Resizing "comments" boxes in a workbook all at once

[rita]

I do not know how I did it but all my comments (about 200 of them) defaulted
to a size that makes them almost invisible with only the tails showing. The
only way I can resize them is by going into each one and change the shape. I
gave up after about 50 and I am now desperate for the information contained
in all comments boxes.

Is there a way of making all the boxes the same size in one go? How did I
manage to screw up and how do I avoid doing it again.

Thanks
Rita

 

[Debra Dalgleish]

You could resize them programmatically. There's sample code here:

http://www.contextures.com/xlcomments03.html#Resize

 

[Dave Peterson]

I'm not sure what you did, but Debra Dalgleish has some code at:
http://www.contextures.com/xlcomments03.html#Resize

that'll help you resize those comments.

And Debra also has some code to move them back to where they belong (if they've
wandered off):
http://www.contextures.com/xlcomments03.html#Reset

(they're right next to each other!)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm