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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies