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


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


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()
ActiveWindow.Zoom = True
End Sub

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

Hi wozza61

Have a look @ this