See Roger's answer that use a macro with the shorcut Ctrl v
You can add the macro in your personal.xlsb

See
http://www.rondebruin.nl/personal.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vernon Balbert" wrote in message . net...
On 11/4/2007 8:54 AM, Ron de Bruin went clickity clack on the keyboard
and produced this interesting bit of text:
Hi Vernon
"Paste Values" is grayed out
If the clipboard is empty it is also grayed out when you copy/paste in
Excel

If you copy from a webpage use the text option in the dialog you get.
The PasteSpecial values option is not working then

But the question is, is there a way to just make this the default way of
pasting text, rather than having to go through the context menu?

--
A belly button is for salt when you eat celery in bed.