The following code restrict to paste values only. This code is to be put in under the Microsoft Excel Objects ThisWorkbook (i.e. not under any module). It works fine for the workbook in which this code is pasted.
What i want is to make this universal, i mean this code should work for all workbooks that are open. If someone copies data from a workbook which has this code and paste the data in other workbook, this code needs to work for that too.

Please Login or Register  to view this content.