Overriding the Paste function in Excel

p0tbelly

New Member
Joined
Sep 15, 2002
Messages
2
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,042
Members
412,358
Latest member
Eng Muhammed
Top