hello,

I made an excel worksheet for out customers.

First everything went ok, but now they have a guy who does constantly
paste from other worksheets. The problem is on our excel sheet, several
columns have validations and when the user copys cells from other
sheets, excel also copies the validation.
= this has made our excel sheet corrupted already several times and we
needed to deliver the original one.

I told him so much: you must do: "paste values" instead of just
"paste", but i think he just likes teasing us.

so, now I'm thinking: isn't there a way in excel to do the following:
- disable all normal exel paste functionality (ctrl V, toobar, menu)
- only allow "paste values" in menubar and toolbar.
- when users do ctrl V: excel does immediately paste values instead of
normal paste.

since i'm not really an excel expert, i hope those three things are
possible. if i need to do some VBA programming, no problems.

thanks in advance


--
stt_d31
------------------------------------------------------------------------
stt_d31's Profile: http://www.excelforum.com/member.php...o&userid=24040
View this thread: http://www.excelforum.com/showthread...hreadid=376492