Overriding the Paste function in Excel

[p0tbelly]

Hi all

I am creating a formatted spreadsheet with borders etc, to be distributed to other users. It needs to allow users to copy and paste from one spreadsheet to this one but with out the formatting e.g. borders being pasted as well. I know I can use paste special to do this but I need a solution, which will override the normal paste function so that when the user uses paste it automatically does the paste special instead. Removing the need for the user to use paste special.

If anyone knows of a solution to this it will be much appreciated.

Cheers