Paste Special in Excel as standard

Question

Is there a way where I can make an Excel file where whenever you copy something from it then it will automatically use paste special formatted as values? Even if you paste in another Excel file.

Answer 1

I've found a solution where I run a on-key event macro which looks like this:

Sub Paste_Special()
  On Error Resume Next

If Err = 1004 Then
  Exit Sub
Else
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
  Application.CutCopyMode = False
End If

Err.Clear
On Error GoTo 0
End Sub

And it works between Excel files as long as the file where the macro originate from is open.

Answer 2

Just add the paste special icon to the quick access toolbar, then it is available in any spreadsheet. As a bonus this becomes easily accessible by a keyboard shortcut as well, just press ALT and the given alphanumeric. See the images below.

When you copy, the information is passed into to clipboard but, AFAIK, there is no way to pass a parameter let alone have that modify the paste function.