Forum Discussion
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...
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.
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.