I have an Excel spreadsheet with a lot of comments that I need to set the
properties for (they're causing an error but I need to keep them). I need to
set the properties of the comments to "move and size with cells" to eliminate
the error I'm getting. Is there a way to set this with VBA or a way to select
all of the comments and change the formatting for them all at once? If you
double-click on a comment and bring up the Format Comment dialog box, then go
to the Properties tab, I need to set the Object positioning to "Move and size
with cells" for about an hundred comments. What's the best way to accomplish
this?

Tom