エクセル 右クリックメニューに登録 値の貼り付け
Sub pastepaste() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False End Sub Sub main() Dim myCBCtrl As CommandBarButton Set myCBCtrl = Application.CommandBars("Cell").Controls.Add(Type:=msoControlButton, ID:=370, Before:=4, temporary:=True) myCBCtrl.Caption = "値の貼り付け" myCBCtrl.OnAction = "SortFunction.pastepaste" End Sub