C
Cumberland
Hi.
I have written a short macro to add items to the right-click menu, bu
am having difficulty finding the right ID numbers. So far, I hav
managed to add "Paste Values" and "Paste Formatting", as below:
Sub AddItems()
'Paste Values
Application.CommandBars("cell").Controls.Add Type:=msoControlButton
ID:=370, before:=5
'Paste Formatting
Application.CommandBars("cell").Controls.Add Type:=msoControlButton
ID:=369, before:=5
End Sub
I also want to add the following:
- Paste Formulas
- Paste Comments
But I don't know the relevant ID numbers! Please can anyone tell m
what they are?
Thanks
I have written a short macro to add items to the right-click menu, bu
am having difficulty finding the right ID numbers. So far, I hav
managed to add "Paste Values" and "Paste Formatting", as below:
Sub AddItems()
'Paste Values
Application.CommandBars("cell").Controls.Add Type:=msoControlButton
ID:=370, before:=5
'Paste Formatting
Application.CommandBars("cell").Controls.Add Type:=msoControlButton
ID:=369, before:=5
End Sub
I also want to add the following:
- Paste Formulas
- Paste Comments
But I don't know the relevant ID numbers! Please can anyone tell m
what they are?
Thanks