For paste special to work both the workbooks must be open in the same
instance of XL.
--
HTH...

Jim Thomlinson


"XP" wrote:

Using Office 2003 and Windows XP;

On the Paste button drop down (standard toolbar), in certain workbooks, the
"Values" option is not available. Even though I do a very basic copy of two
values in one column from another workbook.

Even though protection is turned off at both the sheet and workbook levels,
this function is grayed out.

I tried to manually turn it back on in code using:

CommandBars("Standard").Controls(12).Controls(2).E nabled = True

But this neither causes an error nor enables the control. What would cause
this behaviour and how can I fix it?

Thanks much for your assistance.