There is no builtin shortcut for that you would have to create your
own macros and shortcut key, or assign it to a toolbar button
Toolbars, Custom Buttons and Menus
.
http://www.mvps.org/dmcritchie/excel/toolbars.htm
Sub toggle_comment_indicator()
If Application.DisplayCommentIndicator = xlNoIndicator Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
ElseIf Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlNoIndicator
End If
End Sub
You can check existing shortcuts so you don't override something else
Shortcut Keys in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"jbsand1001" wrote in message ...
Thanks, But what I really want to do is find out either what the keyboard
shortcut to pull up the "popup menu" or find a keyboard shortcut to toggle
between comments to edit.
Thanks,
"bigwheel" wrote:
"jbsand1001" wrote in message
...
I am trying to toggle between comments in Excel but I have to use the
toolbar
and I wanted to see if there are any keyboard short cuts that would allow
for
this?
Have you tried right-clicking the commented cell and choosing one of the
comment options from the popup menu?