Sizing windows automatically

  • Thread starter Thread starter tom Troyer
  • Start date Start date
T

tom Troyer

I am writing an Excel program to distribute to my clients
in the water biz.

I'd like to know if I need to include code to adjust
screen or window sizes to account for each user's display
settings.
 
Maybe you can just set the zoom factor to fit your data nicely.

Application.Goto Worksheets("sheet1").Range("A8:AG8"), scroll:=True
ActiveWindow.Zoom = True

I like to include one extra skinny column at the right. Sometimes it makes it
look nicer.
 

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

Screen size and Window size 5
HyperLink _ to show detail? 7
Set up Automatic Unattended Security Updates on Ubuntu 18.04 or Mint or any Debian. 6
ASUS Z390 Motherboards Automatically Push Software into Your Windows Installation 1
Macro Help in Pivot 2
Window Maker a very fine window manager. 32
Question about User Form Window Size on Chip Petersons Site 9
Window size 2

Back
Top