Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom window to selection
How can I get Zoom window to display the selection only?
I¹d prefer this to apply to the whole workbook regardless of which worksheet is displaying |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom window to selection
You mean in the display to the user, right? I just did a little
experimenting, and Activate works. At least, I told my program to do this: ActiveSheet.Cells(100, 100).Activate ....and the display jumped straight to that spot. Seems to me it would work with Window.Selection too. I didn't test this, but I suppose it may be that once you scroll away from the selection without deactivativing it, Activate won't jump back to it again. But that's easy; you could just Activate something else and then Window.Selection.Activate again. --- "Won" wrote: How can I get Zoom window to display the selection only? I¹d prefer this to apply to the whole workbook regardless of which worksheet is displaying |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the zoom size of a new window from 100% to 75% | Excel Discussion (Misc queries) | |||
Zoom Window Selection Possible? | Excel Programming | |||
Excel Window zoom | Excel Programming | |||
Position Form on screen v Window Zoom ! | Excel Programming | |||
Excel Window Zoom Problems | Excel Programming |