Home

Add New note New comment missing from Excel context menu

%3CLINGO-SUB%20id%3D%22lingo-sub-883197%22%20slang%3D%22en-US%22%3EAdd%20New%20note%20New%20comment%20missing%20from%20Excel%20context%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883197%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20working%20in%20a%20spreadsheet%20for%20several%20hours%20saving%20my%20work%20periodically.%26nbsp%3B%20Within%20two%20of%20those%20hours%20I%20suddenly%20lost%20the%20ability%20to%20add%20a%20new%20note%20or%20a%20new%20comment.%26nbsp%3B%20I%20right%20clicked%20on%20the%20cell%20that%20I%20wanted%20to%20add%20the%20note.%20Surprised%20to%20see%20the%20options%20were%20missing.%26nbsp%3B%20I%20found%20instructions%20for%20a%20work%20around%20that%20I%20pasted%20below.%26nbsp%3B%20However%2C%20I%20cannot%20get%20past%20Step%204%20(Press%20F5%20to%20run%20the%20code)%26nbsp%3B%20It%20presented%20an%20error.%26nbsp%3B%20I%20clicked%20'debug'%20and%20an%20arrow%20showed%20me%20the%20line%20with%20the%20error%20but%20no%20suggestion%20as%20to%20how%20to%20correct.%26nbsp%3B%20I%20still%20can't%20add%20notes%20or%20comments%20to%20my%20Excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-2020348349%22%20id%3D%22toc-hId-2020349025%22%20id%3D%22toc-hId-2020349025%22%3EMissing%20New%20Comment%20and%20New%20Note%20from%20Excel's%20context%20menu%3C%2FH1%3E%3CP%3E%3CI%3ELast%20Updated%3A%20August%2030%2C%202019%3C%2FI%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EISSUE%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20you%20have%20customized%20Excel's%20right-click%20context%20menu%20(possibly%20using%20an%20add-in)%2C%20you%20may%20discover%20that%20the%20%3CSTRONG%3ENew%20Comment%3C%2FSTRONG%3E%2C%20and%20%3CSTRONG%3ENew%20Note%3C%2FSTRONG%3E%20options%20are%20missing%20after%20you%20update%26nbsp%3BOffice.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSTRONG%3ESTATUS%3A%20WORKAROUND%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ETo%20fix%20this%2C%26nbsp%3Breset%20your%20customized%20context%20menus%20using%20VBA%20(Visual%20Basic%20for%20Applications).%26nbsp%3B%3C%2FP%3E%3CP%3EFollow%20these%20steps%20to%20implement%20the%20workaround%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%3EOpen%20the%20Visual%20Basic%20Editor%20(VBE)%20by%20pressing%20%3CSTRONG%3EAlt%2BF11%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EInsert%20a%20new%20module%20from%20%3CSTRONG%3EInsert%20%3C%2FSTRONG%3E%26gt%3B%20%3CSTRONG%3EModule%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ECopy%20and%20paste%20the%20following%20code%20into%20the%20empty%20module%20pane%20on%20the%20right%3A%3C%2FP%3E%3CP%20class%3D%22%22%3ESub%20ShowButtonsAgain()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20Dim%20bar%20As%20CommandBar%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20For%20Each%20bar%20In%20Application.CommandBars%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20bar.Reset%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20Next%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EPress%20%3CSTRONG%3EF5%3C%2FSTRONG%3E%20to%20run%20the%20code.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EExit%20back%20to%20Excel%20by%20pressing%20%3CSTRONG%3EAlt%2BQ%3C%2FSTRONG%3E%2C%20and%20verify%20that%20the%20Comment%20and%20Note%20options%20have%20been%20restored.%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIf%20the%20issue%20recurs%2C%20then%20you%20can%20create%20a%20reusable%20procedure%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%20class%3D%22%22%3EFollow%20steps%201-5%20above.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ESave%20the%20workbook%20in%20a%20convenient%20location%20where%20you%20can%20quickly%20access%20it%20if%20needed.%20Alternately%2C%20you%20can%20save%20it%20in%20Excel's%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcopy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPersonal%20Macro%20Workbook%3C%2FA%3E%20if%20you%20always%20want%20to%20have%20the%20procedure%20available.%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-883197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883369%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20New%20note%20New%20comment%20missing%20from%20Excel%20context%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358473%22%20target%3D%22_blank%22%3E%40JanJaw%3C%2FA%3E%26nbsp%3BThe%20code%20works%20fine%20for%20me.%20What's%20the%20specific%20error%20message%3F%20And%20what%20version%20of%20Excel%20are%20you%20running%3F%20You%20can%20get%20that%20by%20going%20to%20File%20%26gt%3B%20Account.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JanJaw
New Contributor

I was working in a spreadsheet for several hours saving my work periodically.  Within two of those hours I suddenly lost the ability to add a new note or a new comment.  I right clicked on the cell that I wanted to add the note. Surprised to see the options were missing.  I found instructions for a work around that I pasted below.  However, I cannot get past Step 4 (Press F5 to run the code)  It presented an error.  I clicked 'debug' and an arrow showed me the line with the error but no suggestion as to how to correct.  I still can't add notes or comments to my Excel spreadsheet.

 

Missing New Comment and New Note from Excel's context menu

Last Updated: August 30, 2019

ISSUE

If you have customized Excel's right-click context menu (possibly using an add-in), you may discover that the New Comment, and New Note options are missing after you update Office.

 

STATUS: WORKAROUND

To fix this, reset your customized context menus using VBA (Visual Basic for Applications). 

Follow these steps to implement the workaround:

  1. Open the Visual Basic Editor (VBE) by pressing Alt+F11.

  2. Insert a new module from Insert > Module.

  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.

If the issue recurs, then you can create a reusable procedure:

  1. Follow steps 1-5 above.

  2. Save the workbook in a convenient location where you can quickly access it if needed. Alternately, you can save it in Excel's Personal Macro Workbook if you always want to have the procedure available.

1 Reply

@JanJaw The code works fine for me. What's the specific error message? And what version of Excel are you running? You can get that by going to File > Account.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies