I don't have a way to keep them from moving, but Debra Dalgleish has a way to
move them back:

http://www.contextures.com/xlcomments03.html#Reset

Mervyn Thomas wrote:

If I attach a note to a cell in a custom view and then change to a different
custom view where many of the columns are hidden the note moves across to a
different place! Any ideas on how to keep the note static?

--

Dave Peterson