Hi,
I'm making the not-so-fun transition from Excel 2000 to Excel 2007. I used to have a hotkey assigned so that Alt-C would insert a comment in the active cell - it was the same as if I clicked the "Insert comment" button. I am trying to replicate that functionality in Excel 2007.
It appears as though I will have to write a macro that does this, because there are no more custom toolbars with custom hotkeys as far as I can tell.
I tried the following macro (recommended on some website):
Sub InsertCommentNow()
Application.CommandBars.FindControl(ID:=2031).Execute
End Sub
However, this just inserts an empty comment and immediately closes / hides the comment dialogue box; in order to actually put something in the comment box, I have to right-click on the cell and click "Edit Comment", which defeats the purpose of having a keyboard shortcut.
This is driving me crazy! Thanks in advance for your help.
I'm making the not-so-fun transition from Excel 2000 to Excel 2007. I used to have a hotkey assigned so that Alt-C would insert a comment in the active cell - it was the same as if I clicked the "Insert comment" button. I am trying to replicate that functionality in Excel 2007.
It appears as though I will have to write a macro that does this, because there are no more custom toolbars with custom hotkeys as far as I can tell.
I tried the following macro (recommended on some website):
Sub InsertCommentNow()
Application.CommandBars.FindControl(ID:=2031).Execute
End Sub
However, this just inserts an empty comment and immediately closes / hides the comment dialogue box; in order to actually put something in the comment box, I have to right-click on the cell and click "Edit Comment", which defeats the purpose of having a keyboard shortcut.
This is driving me crazy! Thanks in advance for your help.