Zoom value

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

Even though retained with the sheet, Zoom is a property of the window
object - so the answer would be no to the best of my knowledge.

--
Regards,
Tom Ogilvy

"Glen Mettler" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
>
>
>

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


<[email protected]/delete> wrote in message
news:[email protected]...
>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
>>
>>
>>

Why did you have to set the zoom level on the workbook open event? I have
never seen the zoom level change spontaneously. Was this a problem (zoom
level changes of its own accord), ill behaved users or just overcautious? .


--
Regards,
Tom Ogilvy


"gocush" <[email protected]/delete> wrote in message
news:[email protected]...
> 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
> >
> >
> >

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> <[email protected]/delete> wrote in message
> news:[email protected]...
> >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
> >>
> >>
> >>
>
>

I often set the zoom level on the "Lists" sheet to 60 so I can see more data
during any coding / troubleshooting. So...when I start I want to make sure
it is set to 100.

Glen

"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> Why did you have to set the zoom level on the workbook open event? I have
> never seen the zoom level change spontaneously. Was this a problem (zoom
> level changes of its own accord), ill behaved users or just overcautious?
> .
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "gocush" <[email protected]/delete> wrote in message
> news:[email protected]...
>> 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
>> >
>> >
>> >
>
>

Question was for gocush. You never stated that you were setting it in the
workbook_open event.

--
Regards,
Tom Ogilvy

"Glen Mettler" <[email protected]> wrote in message
news:[email protected]...
> I often set the zoom level on the "Lists" sheet to 60 so I can see more
data
> during any coding / troubleshooting. So...when I start I want to make
sure
> it is set to 100.
>
> Glen
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:%[email protected]...
> > Why did you have to set the zoom level on the workbook open event? I
have
> > never seen the zoom level change spontaneously. Was this a problem
(zoom
> > level changes of its own accord), ill behaved users or just
overcautious?
> > .
> >
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "gocush" <[email protected]/delete> wrote in message
> > news:[email protected]...
> >> 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
> >> >
> >> >
> >> >
> >
> >
>
>

to correct ill behaved users

"Tom Ogilvy" wrote:

> Why did you have to set the zoom level on the workbook open event? I have
> never seen the zoom level change spontaneously. Was this a problem (zoom
> level changes of its own accord), ill behaved users or just overcautious? .
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "gocush" <[email protected]/delete> wrote in message
> news:[email protected]...
> > 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
> > >
> > >
> > >
>
>
>

Thanks. I wondered if there was a problem with the zoom setting

--
Regards,
Tom Ogilvy

"gocush" <[email protected]/delete> wrote in message
news:[email protected]...
> to correct ill behaved users
>
> "Tom Ogilvy" wrote:
>
> > Why did you have to set the zoom level on the workbook open event? I
have
> > never seen the zoom level change spontaneously. Was this a problem
(zoom
> > level changes of its own accord), ill behaved users or just
overcautious? .
> >
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "gocush" <[email protected]/delete> wrote in message
> > news:[email protected]...
> > > 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
> > > >
> > > >
> > > >
> >
> >
> >