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.