Always paste plain text in Excel 2007

[throwaway12]

I copy and paste a lot of data from websites into Excel, and I'm tired of choosing Paste Special every time.

How can I force Excel to paste as plain text with no formatting?

I found this macro elsewhere and it works some of the time, but it causes errors when copying and pasting within the same Excel sheet or if you try to paste the same text twice.

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

[throwaway12]

I'm guessing that the problem is the Format. Is there a way to detect whether the text in the clipboard is HTML or plain text?

[throwaway12]

I'm still stuck trying to detect whether the text is HTML or plain text before pasting. Any ideas on how to do this?