"Paste Cell Comments" in Quick Access Toolbar

Question

I am trying to add the "Paste Comments" command to the Excel Quick Access toolbar.

So far have been unable to identify the command in the Excel Options > Customize the Quick Access Toolbarthat allows me to paste cell comments.  

I have found the commands for the other common Paste Special paste options (such as paste formulas, paste values, paste formats), but I have not been able to find the "Paste Comments".

Could someone please direct me to the name of the command that I am looking for?

Thank you,

Scott

Answer 1

s,

re:  pasting comments

I believe you are going to have to settle for the Paste Special button.

But that command is already available on the cell right-click menu.

For me, the right-click menu is more convenient than the QAT.

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 2

Thanks Gord,

This will be the route that I ultimately take.  

I was hoping that there would be a QAT command so that I could always undo the action (and actions prior to the "paste comments" macro) if need be.

Thanks again,

Scott

Answer 3

Thanks Jim,

Glad to know that that QAT Command for this doesn't actually exist, buried under an inconspicuous name.

Thanks again,

Scott

Answer 4

Interested in a macro you can attach to a custom button on the QAT?

Sub Comment_Only_PasteSpecial()

    With Selection

        .PasteSpecial Paste:=xlPasteComments

        Application.CutCopyMode = False

    End With

End Sub

Gord