What is interesting/confusing is that the article is for Excel 97.
According to the article, the problem has been fixed in Excel 2000.

the cited article describes 4 requirements:
The Input range of the control is linked to a second worksheet.

-and-
.. You zoom both worksheets to percentages other than 100 percent.

-and-
.. The zoom percentage of the two sheets are not equal.

-and-
.. You move a toolbar over the control, click the control and choose values,
or you alternately select each of the two worksheets.

None of them mention a userform and you don't mention a toolbar. So, while
your problem may be related, it certainly isn't the one described as being
fixed in the article. (not to say it is fixed either - don't know; haven't
tested it).

Just for interest, there were several other articles on xl97 that were
related to the zoom percentage and out of memory errors.

--
Regards,
Tom Ogilvy


"Glen Mettler" wrote in message
...
Thanks gocush,
The reason for this set up is an intrinsic bug with Excel. I was having
problems with a user form that triggered an error message - "Not enough
systems resources to display completely." I discovered in the Knowledge
Base that this message can be triggered if the zoom value of the
source-data
sheet was less than 100 and different from the active sheet. When I
changed
the zoom of the source-data sheet to 100, the problem went away. (
Article
ID:183503 )

What is interesting/confusing is that the article is for Excel 97.
According to the article, the problem has been fixed in Excel 2000.

===========================
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.

=============================

I am using Excel 2002, so I am wondering what is going on here? Anyway,
seems that the problem is solved for me if I keep the source-data sheet at
100 which I will set during the Auto_Open event.

Thanks for the feedback.

Glen


/delete wrote in message
...
I don't know if this helps but some of the apps I have built require, or
at
least appear best with different zoom values for each sheet. During the
Wbk_Open event I set ScreenUpdating to False, activate each sheet and
set
its
zoom, then continue with other code. The zoom value of each sheet
remains
until changed again.

"Glen Mettler" wrote:

I can change the zoom value of a window with:
ActiveWindow.Zoom = 75

Is it possible to change the value of another sheet without activating
it?
Sheets("MySheet").zoom = 75 does not work

Glen