Microsoft Excel: Zoom value ,Microsoft Excel.

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

Keywords & Tags: zoom, value, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495214/

«« Prev - Next »» 9 helpful answers below.

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" <glen.e.mettler...lmco.com> wrote in message
news:OCNYwaFHFHA.1096...tk2msftngp13.phx.gbl...
> 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
>

tom | Fri, 23 May 2008 05:44:00 GMT |

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

gocushnot_this | Fri, 23 May 2008 05:45:00 GMT |

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

<gocushNOT_THIS...comcast.net/delete> wrote in message
news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
>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
>>

glen | Fri, 23 May 2008 05:47:00 GMT |

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" <gocushNOT_THIS...comcast.net/delete> wrote in message
news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
> 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
> >
> >
> >

tom | Fri, 23 May 2008 05:47:00 GMT |

> 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" <glen.e.mettler...lmco.com> wrote in message
news:eN$wgiNHFHA.3196...TK2MSFTNGP15.phx.gbl...
> 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
>
> <gocushNOT_THIS...comcast.net/delete> wrote in message
> news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
> >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
> >>
> >>
> >>
>

tom | Fri, 23 May 2008 05:48:00 GMT |

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" <twogilvy...msn.com> wrote in message
news:%23eswXhPHFHA.3588...TK2MSFTNGP14.phx.gbl...
> 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" <gocushNOT_THIS...comcast.net/delete> wrote in message
> news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
>> 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
>> >
>> >
>> >
>

glen | Fri, 23 May 2008 05:49:00 GMT |

Question was for gocush. You never stated that you were setting it in the
workbook_open event.
--
Regards,
Tom Ogilvy

"Glen Mettler" <glen.e.mettler...lmco.com> wrote in message
news:eyQ1U7THFHA.580...TK2MSFTNGP15.phx.gbl...
> 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" <twogilvy...msn.com> wrote in message
> news:%23eswXhPHFHA.3588...TK2MSFTNGP14.phx.gbl...
> > 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" <gocushNOT_THIS...comcast.net/delete> wrote in message
> > news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
> >> 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
> >> >
> >> >
> >> >
> >
> >
>

tom | Fri, 23 May 2008 05:51:00 GMT |

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" <gocushNOT_THIS...comcast.net/delete> wrote in message
> news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
> > 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
> > >
> > >
> > >
>
>

gocushnot_this | Fri, 23 May 2008 05:52:00 GMT |

Thanks. I wondered if there was a problem with the zoom setting
--
Regards,
Tom Ogilvy

"gocush" <gocushNOT_THIS...comcast.net/delete> wrote in message
news:14303836-33C3-475F-9289-C6A7481CDE42...microsoft.com...
> 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" <gocushNOT_THIS...comcast.net/delete> wrote in message
> > news:4EBF8642-E8CC-42CF-B32E-460557F6AD63...microsoft.com...
> > > 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
> > > >
> > > >
> > > >
> >
> >
> >

tom | Fri, 23 May 2008 05:53:00 GMT |

Microsoft Excel Related Links

Microsoft Excel Hot Answers

ZOrder of two forms
Here's the scenario: I have two forms to display on the screen: Form1 and Form2. The Form2 is displayed after the user clicks a button on Form1 (which is already displayed). Form2 is automatically displayed in front of Form1. Both forms are loaded modeless (you can't load a second form...
Zorder doing strange things
Can anybody explain what's going on here ? Put two listboxes and two commandbuttons on a form and partially overlap the two listboxes. The code below should alternately bring to the front and then to the rear Listbox2. Private Sub CommandButton1_Click() ListBox2.ZOrder (0) End Sub Private S...
ZOrder Behavior Changed in Excel 2007?
Argh! Form controls now *always* appear on top of shape/drawing objects. What's up with that? Prior versions of Excel allows you to send Form controls behind shape objects by right clicking on them and choosing "Order->Send to back". Ok, so you're probably asking "why would you ever...
Zoomed in files
Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like t...
Zoombox
Dear All, I want to be able to open the zoombox on pressing shortcut (? a free one) for all cells in column R and S . Thanks³ Filip...

Microsoft Excel New questions

Zoom to fit the page width
Hi,I have an excel workbook with multiple sheets. It is been used on differentcomputers and I would like my workbook to zoom always to right screen width.How can I do this?I have freezed panes on top of every sheet with a background picture thathas a width of 33,52 cm. I would like to have scree...
Zoom to fit the page width
Hi, I have an excel workbook with multiple sheets. It is been used on different computers and I would like my workbook to zoom always to right screen width. How can I do this? I have freezed panes on top of every sheet with a background picture that has a width of 33,52 cm. I would like to have...
Zoom to 400%
Whenever a user opens an Excel Spreadsheet the sheet automatically zooms to 400%. This happens when the user is connected to a projector or second monitor. I have updated the display driver and downloaded all MS Office Updates. Nothing else seems to be having issues except Excel and Word. The on...
Zoom property error
I have a workbook with a chart and i have some VBA code to format the chart, etc., but there is an instruction that gives a Run Time error. The instruction is "ActiveWindow.Zoom=100". The error is: Run-Time Error '1004' "Unable to set the zoom property of the windo2 class." Can someone...
Zoom property
Please you know why setting the Window.Zoom property can have no effect on an activedocumenthost? Thnak you....
Zoom property
Please you know why setting the Window.Zoom property canhave no effect on an activedocumenthost?Thnak you....
Zoom Problems in Excel 2002
When viewing a speadsheet at 50% or 75%, the number 1 does not line up properly in the column with the other numbers. I am using arial 12 font. When it is full screen, it lines up perfectly. Unfortunately, I need to see the whole speadsheet at one time, hence the 50% or 75%. Any help would be gr...
zoom problem with textboxes
I've created a data entry Excel file at work, and have placed severa text boxes on the sheet to let users enter notes. My usual scree resolution is 800X600, so this is the resolution I created th application in, and am having no problems at this resolution. However some users have their scr...
zoom out for printing in Excel 2002
My work sheet only prints on the first half of the page width? Setup and margins don't seem to work so I can print larger. My worksheet prints out 4" wide and 2" deep. I want it to print the full page' ANy help is appreciated...
Zoom on selection
I have the following code to "zoom" on a selection of one or more chosen cells.: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range ("B63:B65,G47:G48,G53,G64,G65,L58,L60:l65,M3")) Is Nothing Then ActiveWindow.Z...

Microsoft Excel Related Categories

Microsoft Excel

(Microsoft Excel)Q&A: 'Zoom value', With 9 answers.

Microsoft Excel: Zoom value

Keywords & Tags: zoom, value, microsoft, excel

Microsoft Excel Related Links

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories

Microsoft Excel