MrExcel Publishing
Your One Stop for Excel Tips & Solutions

automatic window sizing to screen resolution


Posted by wozza61 on May 21, 2000 9:06 PM

Hi all,
can anyone tell me how I can set up a spreadsheet to automaticaly size to the screen's resolution
so it won't matter which computer someone sees it it will look the same

Regards
wozza61


Posted by Celia on May 22, 2000 3:36 AM


wozza61

Not sure whether it works or not but try experimenting with Zoom in an event procedure. For example, try putting the following macro in a Worksheet module :-

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("A1:P40").Select
ActiveWindow.Zoom = True
End Sub


Posted by Ivan Moala on May 22, 2000 4:01 AM

Hi wozza61

Have a look @ this
http://www.j-walk.com/ss/excel/tips/tip06.htm

Ivan