How do I expand more than one comment box at same time?

[carol]

saved a copy of a data base and all the comment boxes reduced in size so
unreadable. Need to expand all comment boxes at one time or find out why
saving a file with new name changes size of orginal comment box

 

[Gord Dibben]

See Debra Dalgleish's site for code.

Note two sets of code...one for worksheet.....one for a range.

http://www.contextures.on.ca/xlcomments03.html#Resize


Gord Dibben MS Excel MVP