Why not create macros to copy the values for the users? you can control what
they copy and where it goes.


"nickm687" wrote in message
oups.com...
Maybe i should rephrase.

I am hoping to lock a worksheet so that only paste values is allowed.

therefore whenever a user goes to paste it is only the the values,
nothing else. the worksheet i am using contains much formatting but
requires copying from another workbook, which in turn messes up
everything.

Regards
Nick