resize and move all comments in one step

[EvelynB]

I am needing to resize and move all my comments on my workbook to their
relevant cells as when I try to hide or group colums it says that I "can't
move objects off sheet". I assume that this is because my comments seem to
have a life of their own and have landed up in random places on my worksheet.
Please help!

 

[Dave Peterson]

I'd use a macro.

Debra Dalgleish has a couple for you:
http://contextures.com/xlcomments03.html#Reset
http://contextures.com/xlcomments03.html#Resize

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

(Look for merged cells, too.)

 

[FSt1]

hi
there is a wealth of information on comments at this site. this link directs
you to reseting and resizing but scroll up and down the page for more infor
on more stuff.
http://www.contextures.com/xlcomments03.html#Reset

regards
FSt1