Zoom window to selection (further clarification)

  • Thread starter Thread starter Won
  • Start date Start date
W

Won

Sorry, I did not explain this very well in my previous post.

I¹d prefer that I do not have to name each worksheet in the macro, just be
able to select the cells in the frontmost worksheet, then apply the macro
zoom to fit the window.
 
Select some cells and then run:

Sub Macro1()
ActiveWindow.Zoom = True
End Sub

If you assign a shortcut key to the macro, it will be super easy to use.
 

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

Zoom window to selection 1
Zoom Window Selection Possible? 3
zoom in on range 1
adjust zoom according to sheet 3
PageSetup.Zoom=TRUE 3
**Increase Font Size for Selected Cell** 2
zoom problem ?? 6
Applying a specific Print setting to all worksheets 1

Back
Top