Auto Paste Special VB Code

[FXA]

How do I get this to work in Excel?

ActiveSheet.PasteSpecial Format:="TEXT", Link:=False, DisplayAsIcon:= _
        False, NoHTMLFormatting:=True

Thank you in advance

 

[zero269]

Yes, instead of right clicking, want it to automatically do this when pasting

Sorry for the late reply...
Here's a macro that I use:

' Paste To Active Cell
Sub PasteTextOnly()
    ActiveSheet.Activate
    ActiveSheet.PasteSpecial Format:="Text"
End Sub

I use this in just one Sheet (Macro button) where I'm copying/pasting several values from a website.
However, based on some of the other responses, it appears you may be looking to change the Default Paste as well.... that's definitely a great option, too.