Let's try again: VBA Code stops randomly

[DavidAtCaspian]

Thanks for the input, but what I'm really after is getting perfectly good
code to run without being interruped by an 'impossible' event. Surely someone
must know the likely cause of this? (ie I'd really like the product to work
the way it is supposed to).

We have tried something new today, and since then one the one machine we
tried, has not had a recurrence of the problem.

Would anyone else like to give it a go, and let us know if it works for you?

Do a search in Office for turning off the office multi level clip board.
(Personally I've always found this feature to be nearly as irritating as that
paper clip). - It is a registry fix at office level, and reverts to just the
one clipboard.

As I said, we've done this on one machine and not had the problem again. --
BUT then again, none of the other machines have gone wrong today either.!!!

By the way, we're on Excel 2002 SP3, and XP (some at SP1, some at SP2), and
IE6.


David

 

[John Keith]

I will give it a try!

But I cant seem to find anything about how to turn off the office multi
level clip board. Can you post the steps or point me to where you found the
instructions.

 

[DavidAtCaspian]

John:

Try this link for full instructions.

http://www.annoyances.org/exec/show/article08-803

The one machne we did this on has not had the problem again (we re-booted
after making the setting).

BUT

None of the other machines has had a re-occurence either!!!


David

 

[John Keith]

Issue resolved... for now.

Before I had a chance to try the changes in the registry to turn off the
multi-clipboard feature, a windows update came through which rebooted the PC.
I really doubt the windows update has anything to do with the issue
resolving itself. I think the reboot is what solved the problem. My PC
stays up all the time and I rarely reboot. But since then, the random breaks
have ceased. I did bookmark the page you linked and if I do have the problem
show up again and a simple reboot doesn't solve the problem I'll give it a
try.