problems with screen size

P

praptisahni

i regularly email excel sheets to various departments in our office
almost all the people use the screen size 1024X768, even though th
screen size varies, some use a 15 inch screen whereas others use a 1
inch screen.
normally is set up my excel sheet in such a way that all the column
are visible in that one screen and the user does not need to scrol
right.
however when i set up the columns properly on a 17 inch screen they d
not appear the same on a 15 inch screen.
is there a way for me to ensure that all the columns always autofit o
the screen so that the user need not have to right scroll
 
D

DNF Karran

Make the range in the following your range you want to auto-zoom to and
put it behind the workbook.

Private Sub Workbook_Open()
Range("C4:E9").select
ActiveWindow.Zoom = True
End Sub

Duncan
 
Top