Fixed objects will move
There are two possible workarounds for this issue:
1. If you need to keep the file in Excel 97-2003 format, change the comments' properties to move and size with cells. The following macro will set all comments in the workbook to move and size with cells:
Dim wksht As Excel.Worksheet
Dim wb As Excel.Workbook
Set wb = ActiveWorkbook
For Each wksht In wb.Worksheets
For Each cmt In wksht.Comments
cmt.Shape.placement = xlMoveAndSize
Next cmt
Next wksht
End Sub
2. Save the workbook in Excel 2007-2010 format (XLSX, XLSM, XLSB).