Copy/Paste in Sheet - Values Only

neodjandre

Well-known Member
Joined
Nov 29, 2006
Messages
926
I would like my users to be able to copy and paste freely on a ListObject table, but only values (i.e. not messing with formatting/data validation). Is this possible with a worksheet change event ?

many thanks
Andrew
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,098,863
Messages
5,465,120
Members
406,414
Latest member
Discorz

This Week's Hot Topics

Top