Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Sizing windows automatically

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Sizing windows automatically

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.



tom Troyer wrote:

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.


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot open exel from windows xp in windows vista and visa versa lildiana New Users to Excel 4 February 25th 09 08:26 PM
When I open a document it automatically opens up in 2 windows. mojofaerie Excel Discussion (Misc queries) 1 October 8th 07 05:41 PM
Automatically re-sizing merged cells LongTermNoob Excel Worksheet Functions 1 March 28th 07 10:42 AM
automatically sizing text with graphs Shoque Charts and Charting in Excel 1 August 2nd 06 03:30 PM
Prevent open excel windows from automatically closing. Prevent Automatic Closing Excel Discussion (Misc queries) 1 April 10th 06 10:27 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"