I want to 'repurpose' some of the menus on the Excel 2007 ribbon, in particular to set paste to paste only values. Effectively I need the equivalent of the following for Excel 2007
Code
Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)
Application.CommandBars("Edit").Controls.Item("Paste").OnAction = "New_paste"
Application.CommandBars("Cell").Controls.Item("Paste").OnAction = "New_paste"
End Sub
.
John Walkenbach suggests the following xml code
Code
<customUI xmlns = "http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="Copy" onAction="New_paste"/>
<commands>
</customui>
I'd appreciate any advice on this code or any other way of achieving the same in Excel 2007. Also, I am not sure how where xml goes and how to call it from within a vba routine. Any help much appreciated.
Ian