You haven't gotten much help with this problem and I think that the reason is
that most people don't have this kind of trouble. (Yeah, that doesn't help,
either.)

But you may want to consider rebuilding your workbook--including all the data,
all the shapes/objects/names/code/userforms/pagesetups (yech!).

You may have considered this and realized that even if you spent hours and hours
doing this (and got it correct), it may not fix the problem.

But if it doesn't start behaving better, you may want to build a mini-version of
your workbook to see if you can get it to play nice.

If it starts acting up, at least you didn't spend too much time on the rebuild.

A few months ago, Jan Karel Pieterse was working on a workbook recreator.
http://www.jkp-ads.com

I searched his site, but didn't find any reference to this utility. (Maybe it's
not quite ready to share with the world???)

If you wanted to volunteer to be a guinea pig, you could contact him via his
site:
http://www.jkp-ads.com/Contact.htm

The worst he could say would be no. He might want to hear your results and
knowing Jan Karel, if it didn't work, he's want to get a copy of your workbook
so that he could improve his program.

====
Jan Karel, if you're reading the newsgroup, "hi!"

dransfield wrote:

Here's the latest: I don't know whether I've completely fixed it but
its certainly better:

The sheet I was reading from (and writing to) is also the
ControlSource for some other controls.
That's the only thing that I can think of that makes this sheet
different from the others.
So I split them onto 2 new sheets: Control sources on New1, data I'm
reading from and writing to with code on New2, leaving the original
sheet ("Liss") redundant (and deleteable.

Seems to work better now.
Mark

--

Dave Peterson