Excel 2007 : Disable Paste and replace with paste special values

I have a number of control spreadsheets which my users paste data into daily. Despite asking them to only paste special values to preserve the formats, they often forget and the spreadsheet requires reformatting.

Is there anyway when they open the control spreadsheet I can reassign paste or CTRL-V to paste special values. I've searched long and hard and found a solution for excel 2003 but nothing that seems to work in Excel 2007.

Any help would be greatly appreciated.

Zig.

Paste this code into the VB editor for all of the sheets you want to protect. This is the simplest solution I've seen. Please note that if you already have a "Private Sub Worksheet_Change" on the book then it will cause an error.

Please Login or Register  to view this content.