how to set copy/paste for only values

Hi,

I have problem, that users insert to the table cells from different sheet (it will be allways done manually - ctrl+C and ctrl+V), problem is, that they copy formating as well and destroy the table. Is there possibility to pre-set for Copy/Paste xlPasteValues for the whole book? For example macro in Workbook.open? It's in Excel 2016/2019.

Thank You for tips.

Martin

Try this code in this workbook;

Please Login or Register  to view this content.

It will paste whatever is in the paste buffer (i.e. without Ctrl+V), but will maintain original cell format.

Thank You Croweather. It works, that it insert automaticaly the buffer to the cell, which I select. I would need, that it works this way but not automaticaly, I can select the right cell and than if I use Paste (on right mouse click&paste or menu&paste or Ctrl+V), because here if the user click on false cell, it insert the buffer imediately (can be wrong). But I didn't found the right private sub. Something like Private sub Workbook_BeforePaste.