Auto insert a comment box.

[Chiefgarcia]

I am trying to find a way where I can have excel Insert a comment box
automatically.

For example:
I have a data sheet and every time I need to insert a new row, I then need
to insert a comment box in every cell. Instead of copying and pasting, is
there a way to make excel auto populate the comment box when I insert a new
column?

If so, how or is there a macro that I can use?

Thanks.

 

[dlotz]

do you want the comment ballon to pop up ever time you
select any cell in col.