i wish an excel spread sheet to fill whatever screen size is available on
opening on various pcs,some have 12" some14" and some17"

Use fullscreen under the view menu?

--
Regards,
Tom Ogilvy

"johnw" wrote in message
...
i wish an excel spread sheet to fill whatever screen size is available on
opening on various pcs,some have 12" some14" and some17"

This relies on Excel being maximised before closing. It will then reopen
maximised (ie to fill the screen).

--
Ian
--
"johnw" wrote in message
...
i wish an excel spread sheet to fill whatever screen size is available on
opening on various pcs,some have 12" some14" and some17"

I tried using fullscreen and it still does not fill the screen

"Tom Ogilvy" wrote:

Use fullscreen under the view menu?

--
Regards,
Tom Ogilvy

"johnw" wrote in message
...
i wish an excel spread sheet to fill whatever screen size is available on
opening on various pcs,some have 12" some14" and some17"

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