Another case of part of the question is in the subject title.
Please include the entire question in the body.

You want the equivalent of Edit, Paste Special, Values
after copying your entire worksheet
(Edit, Move or copy, be sure to check copy worksheet)

So a common shortcut would be Ctrl+Shift+V to
paste values using your own macro.
http://www.mvps.org/dmcritchie/excel/paste.htm#values
No matter what your choose Ctrl+Shift+V or Ctrl+Shift+P
you are very likely to override a builtin Excel shortcut, so you
might want to check that to see if you really want that shortcut.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Also note with Edit, Paste Special what your options are.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ups.com...
Of course, that I know that (I am much behind this level), but I need
to assign to key shortcut to Paste values only (so that pasting want
destroy formatting of target cells). ANy thoughts?

Matej