Force PasteSpecial with VBA

B

Barb Reinhardt

I've seen this, but can't find it again today. If a user pastes in a
workbook, I want to force it to be a PasteSpecial/Values. I know this needs
to go in the Worksheet_Change, but am not sure what to put there.

Thanks,

Barb Reinhardt
 
P

PhilosophersSage

I think your are talking about:

..PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Hope this helps.
 
B

Barb Reinhardt

Nope, that's not what I'm looking for. What I need is if a user does a
PASTE, it will undo the paste and pasteSpecial. I've seen it, but can't find
it again.

Thanks,

Barb Reinhardt
 
Top