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...
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) .
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.
- It's unusual activity since Insert Comments & then others are built in commands,,, one you try SHIFT+F2 ,,,, I'm sure this will works.
- Yes. it is working. Thanks Mr. Rajesh.
