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.