Script to paste only values in cell- Excel

[Skopweb]

Hello All
I need help in creating a script for SheetA that should allow to paste values in a cell (like right click -> paste special -> values). Other options like formats, formulas should not be allowed
Regards
Skopweb

[nst1107]

The method is .PasteSpecial. You can use Application.CutCopyMode = False to get rid of the dot highlight afterward if you need to.

[Skopweb]

Can u help me with the script as i'm not literate at scripts
Thanks in advance
Skopweb

[p45cal]

You don't need .PasteSpecial just to paste values.

Use the likes of
Range("A1")=Range("C22").value

to copy from C22 to A1

or

Range("D12:F15")=Range("A3:C6").value

to copy a range of cells at once.

[Skopweb]

well
the need here is that i want to allow only paste special values if from excel and paste special text from any other source
is it possible to help me with the entire script?
actually i have this sheet to distribute to a bunch of thick heads that only know to do ctrl+c and ctrl+v. they find complications on even doing a paste special
please help !!!!!!!!!!!!!!!!

[p45cal]

A google produced:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
http://www.mrexcel.com/forum/showthread.php?t=84495
http://www.jkp-ads.com/articles/catchpaste.asp
http://www.mrexcel.com/forum/showthread.php?t=40428
http://www.xcelfiles.com/VBA_Quick13.html