Home » Questions » Computers [ Ask a new question ]

What's the shortcut in excel to show/hide cell comments?

What's the shortcut in excel to show/hide cell comments?

what's the shortcut in excel to show/hide cell comments?

Asked by: Guest | Views: 451
Total answers/comments: 1
Guest [Entry]

"A modification on Geoffrey van Wyk's VBS - toggles only comment of active cell

Sub Show_Hide_Comment()
'
' This macro toggles the display of selected cell's comment if one exists.
' It does not create one if there is none... for this press Ctl+F2
'
' You may use macros menu to set keyboard shortcut
'
If Not ActiveCell.Comment Is Nothing Then
If ActiveCell.Comment.Visible Then
ActiveCell.Comment.Visible = False
Else
ActiveCell.Comment.Visible = True
End If
End If
End Sub"