You can maximize the application window.
You can maximize the worksheet window.
and you can set the zoom percentage to show what you have selected.
(all in code)

Option Explicit
Sub auto_open()
Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
Application.Goto Worksheets("sheet2").Range("a1:x1"), scroll:=True
ActiveWindow.Zoom = True
End Sub

ceemo wrote:
>
> I have a work book that is used by many users who have different
> resolutions on their PCs's. Is there anyway i can get the workbook to
> adjust itself on open so that a certain range of cells set by me fill
> the workbook.
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
> View this thread: http://www.excelforum.com/showthread...hreadid=396899

--

Dave Peterson