I have a worksheet that requires users to copy columns of data from an outside program and paste the data into the worksheet. The data comes in unformatted, and users have a habit of replacing all the nice looking formatting I'd done with the unformatted data.
Is there a way to override a user's paste with a paste special - values only command? I'd be looking to do this either at the worksheet or workbook level I think, because I'd still want to be able to perform standard paste operations in other workbooks.
If that's not possible, could I somehow run a worksheet_change event that detected a paste operation and reformatted the affected cells to the way I want them on the color/border/banded rows front?
Sorta lost on this one, thanks for any help.
Is there a way to override a user's paste with a paste special - values only command? I'd be looking to do this either at the worksheet or workbook level I think, because I'd still want to be able to perform standard paste operations in other workbooks.
If that's not possible, could I somehow run a worksheet_change event that detected a paste operation and reformatted the affected cells to the way I want them on the color/border/banded rows front?
Sorta lost on this one, thanks for any help.
