johnw Wrote:
i wish an excel spread sheet to fill whatever screen size is available
on
opening on various pcs,some have 12" some14" and some17"Hi John,
See if this is what you are looking for. It has to go into the WorkBook
Module,
and macros have to be enabled.

Private Sub Workbook_Open()
'Opens workbook to full screen
Application.DisplayFullScreen = True
End Sub

Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=466763