Forum Discussion

Fencote's avatar
Fencote
Copper Contributor
Mar 22, 2021

Add / Edit Note to Excel cell has disappeared

I have opened a file I was working on yesterday and have noticed that the ability to Add / Edit Notes and Comments has disappeared from the 'right-click' menu for all cells.  I have not protected any cells or sheets within the Workbook but have no idea why its gone.  Any help would be appreciated.

excel
  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Steel Contributor
    Mar 23, 2021
    If I'm not wrong then you are struggling with COMMENTS,,, do this,,, select the cell then right Click & from the menu find Hide/Unhide Comment,, hit once sets the comment appears (if is hidden) another sets comments disappear ( if is Un-hidden) .
    • Fencote's avatar
      Fencote
      Copper Contributor
      Mar 23, 2021

      Rajesh_Sinha Thanks for the reply.  I am aware of the menu that appears when you highlight a cell and 'right click'.  The issue is that the menu appears when I 'right-click' but the options to Add / Edit / Delete both Notes and Comments has disappeared from the menu.

      • Rajesh_Sinha's avatar
        Rajesh_Sinha
        Steel Contributor
        Mar 24, 2021

        Fencote 

         

        You may try this as a trouble shooter:

         

        Try this VBA Macro:

        • To open the VB Editor  press Alt+F11.
        • Insert a new module from Insert  then Module.
        • Copy and Paste this code. 

         

         

         

        Sub ShowCommandButtons()
   Dim bar As CommandBar
   For Each bar In Application.CommandBars
         bar.Reset
   Next
End Sub

         

         

         

        • Save the WB as Macro Enabled *.xlsm.
        • Press F5 to run the Macro.

         

        N.B.

         

        • Back to sheet & insure that the Comment/Note commands have been restored or not. 
        • Remember Comments is available with every version of Excel but the Note is with higher versions only.

         

Resources