Mar 22 2021 02:51 PM
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.
Mar 23 2021 12:19 AM
Mar 23 2021 02:27 AM
@Rajesh-S 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.
Mar 23 2021 02:46 AM
I'd check in Safe mode (Win+R, excel /safe) if it works or not, next do Office repair.
Mar 23 2021 10:45 PM
Mar 23 2021 10:56 PM - edited Mar 23 2021 11:00 PM
You may try this as a trouble shooter:
Try this VBA Macro:
Sub ShowCommandButtons()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Reset
Next
End Sub
N.B.
May 15 2023 04:51 AM