I can't say why it doesn't work/causes problems - I just know there are
Knowledge base articles that indicate there can be memory problems with
sheets with controls if the zoom is less than 100%. This was more back in
the xl97 time period. I haven't seen many recent posts with this problem,
so it may be less of a problem in later versions. Don't know which version
you are using.

Regards,
Tom Ogilvy

"Dave" wrote in message
...
Hi Tom,

It works when I set the the zoom to 100%. Why does the box function
correctly at 100% but not 75%?

Yes, I am setting the range names manually after the box has been drawn
(no code).

Regards

Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!