How to bring comments/notes back into view?

Dear @York Lin,

Thanks for your response! I truly appreciate your update and effort when go through the solution!

Based on your description, here are detailed step by step to do it:

Step 1: Open Your Excel File

• Open the Excel workbook with the problematic notes on your new laptop.
• Ensure you're on the worksheet with the off-screen notes.

Step 2: Access the VBA Editor

Press Alt + F11 on your keyboard. This opens the Visual Basic for Applications (VBA) Editor.

• If this doesn't work, enable the Developer tab:
  • Go to File > Options > Customize Ribbon.
  • Check the box for Developer in the Main Tabs list, then click OK.
  • In the Developer tab, click Visual Basic.

Step 3: Add the Macro

• In the VBA Editor, look at the Project Explorer on the left (it lists your workbook, e.g., VBAProject (YourFileName.xlsx)).
• Right-click on your workbook's name, then select Insert > Module. A new module (e.g., Module1) appears.
• Double-click the new module to open a blank code window on the right.
• Copy the following code and paste it into the blank code window:

Sub ResetLegacyNotesPositionAndSize()
    Dim ws As Worksheet
    Dim cmt As Comment
    Dim cell As Range
    ' Set reference to active worksheet
    Set ws = ActiveSheet
    ' Loop through all cells with legacy notes in the worksheet
    For Each cell In ws.UsedRange
        If Not cell.NoteText = "" Then
            Set cmt = cell.Comment
            If Not cmt Is Nothing Then
                ' Position note near its cell (top-left corner of cell)
                cmt.Shape.Top = cell.Top
                cmt.Shape.Left = cell.Left + cell.Width + 10
                ' Set standard size for note (width, height in points)
                cmt.Shape.Width = 200
                cmt.Shape.Height = 120
                ' Ensure note is hidden by default (shows on hover)
                cmt.Visible = False
            End If
        End If
    Next cell
    MsgBox "All legacy notes have been repositioned and resized.", vbInformation
End Sub

1. Press F5 to save the code, then close the VBA Editor by clicking the red X or File > Close and
2. Return to Microsoft Excel.

Step 4: Run the Macro

1. In Excel, go to the Developer tab and click Macros (or press Alt + F8).
2. In the Macro dialog box, select ResetLegacyNotesPositionAndSize from the list.
3. Click Run. The macro will process all legacy notes in the active worksheet, moving them to the right of their cells and resizing them to 200x120 points.
4. You’ll see a pop-up message saying, "All legacy notes have been repositioned and resized."

Step 5: Save Your Workbook

Save your workbook as a macro-enabled file to keep the macro:

• Go to File > Save As.
• Choose a location, then select Excel Macro-Enabled Workbook (*.xlsm) as the file type.
• Click Save.

Step 6: Verify the Fix

• Hover over or click cells with notes (indicated by a red triangle in the top-right corner of the cell) to ensure the notes appear near the cell and are properly sized.

Note: It is not automated applying to new notes, only current notes and comments are affected.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.

I'm looking forward for your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.