"New Note" missing in Excel

Anonymous
2023-04-18T00:04:33+00:00

I'm working in Excel with Microsoft Office Professional Plus 2021, updated with Microsoft 365.

For school purposes, I need to be able to add/insert comments and notes to a cell.

Unfortunately, I only have access to comments. So, I can't add a note.

It's not available when I click right on a cell or in the "Review" tab.

I've tried to:

  1. Open the Visual Basic Editor (VBE) by pressing Alt+F11.
  2. Insert a new module from InsertModule.
  3. Copy and paste the following code into the empty module pane on the right: Sub ShowButtonsAgain()
       Dim bar As CommandBar
       For Each bar In Application.CommandBars
             bar.Reset
       Next
    End Sub
  4. Press F5 to run the code.
  5. Exit back to Excel by pressing Alt+Q, and verify that the Comment and Note options have been restored.

Nothing has worked.

Does anyone have a fix?

Thank you so much for your attention and participation.

EDIT: Moved FROM Microsoft 365 and Office / Excel / Unknown / Windows TO Microsoft 365 and Office / Excel / For Education / Windows.

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Anonymous
    2024-01-30T11:58:18+00:00

    I did Unprotect Sheet, and then I could add Notes again. After Protect Sheet again only add Comment possible … 🤔

    0 comments No comments