Hi guys,

Could anyone be able to help me. I have two workbooks where the user
must copy range of cells from one to the other, but only the values.

Is there an automated way of restricting the copy function to only
copy values?

That is, within the first workbook, whenever the user copies some
cells (via Ctrl+C or the toolbar) excel only copies the values.
Therefore, in the second workbook the user only has to paste.

Regards
Nick