Force PasteSpecial with VBA

[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

 

[PhilosophersSage]

I think your are talking about:

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

Hope this helps.

 

[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

 

[maywood]

Maybe this code in another forum helps:
http://www.mrexcel.com/forum/showthread.php?t=56674

 

[Dave Peterson]

Gord Dibben has posted routines that
save the values in the changed range
does an Application.undo
and assigns the values to the changed range.

Here's a version that may get you started:
http://groups.google.com/group/micr...+group:microsoft.public.excel.*+author:dibben

or
http://snipurl.com/tojry