Zoom window to selection

W

Won

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
 
B

Bob Bridges

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a default zoom in Infopath 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
AppleScript - How do I select a text ? 1
Zoom window to selection (further clarification) 2
Word VBA Copy Heading and Content 4
screen resolution vs. zoom vs. activewindow 0
Publisher 2019 Format Picture window size too large to display OK button 0
Menu driven PowerPoint presentations 0

Top