Do you have any addins (application events) running?

If you open excel in safe mode
windows start button|Run
excel /safe

then file|Open your workbook

Can you copy|paste?



Jack Sons wrote:

Dave,

Even if I open Excel anew and open a new workbook (Book1, it is not called
Book1.xls , Book1.xlt or Book1.xla) copying to outside the same sheet is
impossible.

I checked that there is no code whatsoever in any sheet module or the
workbook module of that Book1, it has no code modules.

Jack.

"Dave Peterson" schreef in bericht
...
Do you have any worksheet events firing?

_selectionchange
_change
_deactivate
_activate

(remember to check for workbook level events, too.)

One of the bad things about running macros is that they sometimes kill the
clipboard.



Jack Sons wrote:

Hi all,

Suddenly paste (worksheet function as well as VBA) will work only on the
same sheet, so I can't copy anything to another sheet nor to another
workbook.

This is a real disaster.

Please help. I use XP SP2 with Excel 2k

Jack Sons
The Netherlands

--

Dave Peterson

--

Dave Peterson