案頭支援--Fixed objects will move

標籤：following   possible   objects   change   excel   

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).

案頭支援--Fixed objects will move