Desktop support fixed objects will move

Fixed objects can move.

There are two possible solutions for this problem:

1. if you need to keep the file in Excel 97-2003 format, change the properties of the comments to move and resize with the cell. The following macro will set all comments in the workbook to move and resize with the cell:

Please make the workbook.
Bleak wb for excellent. Workbook
Set wb = ActiveWorkbook

Worksheets for each wksht
For each cmt. comment in wksh. cmt.
cmt.Shape. position = xlMoveAndSize
Next cmt.
Next wksht

2. save the workbook as Excel 2007-2010 format (XLSX, XLSM, XLSB).

Read More: