Force PasteSpecial with VBA

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
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
 
I think your are talking about:

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

Hope this helps.
 
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
 
Back
Top