Look here
http://www.contextures.com/xlcomments03.html#Formatted

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
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