Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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" /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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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" wrote in message ... 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" /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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
Question was for gocush. You never stated that you were setting it in the
workbook_open event. -- Regards, Tom Ogilvy "Glen Mettler" wrote in message ... 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" wrote in message ... 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" /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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
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" /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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom value
Thanks. I wondered if there was a problem with the zoom setting
-- Regards, Tom Ogilvy "gocush" /delete wrote in message ... 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" /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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zoom | Excel Discussion (Misc queries) | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
ZOOM | Excel Worksheet Functions | |||
Can't Zoom | Charts and Charting in Excel | |||
Zoom | Excel Programming |