The first part of this is relatively easy. Right click on a worksheet tab
then select View Code. Double-click the This Workbook object then change the
two selections from (General) and (Declarations) to Workbook and Open, Then
in the sub that gets added enter the line Application.DisplayFullScreen =
True. Next change to Workbook and BeforeClose and enter
Application.DisplayFullScreen = False.

This will then open as full screen and turn off the full screen when the
workbook is closed.

To prevent toolbars being opened your're going to need to change the
built-in menus and renable them on exit. The code could be placed inside the
same subs as above so have a look at
http://msdn.microsoft.com/library/de...l/ofcmdbar.asp for guidance

"skrol" wrote:


Hi,

Normaly Excel opens in the way it was used the last time.
Showing the tool bars/Options that were used the last time.
I want that my file opens in someone else his PC under Full Screen, no
mather how his Excel was configurated the last time.

More,
Is it possible to protect also the fullscreen, so that no toolbars can
be opened, or other things under "Tools / Options" ??
Always keeping Full Screen .

Thanks .....

S.Krol




--
skrol
------------------------------------------------------------------------
skrol's Profile: http://www.excelforum.com/member.php...o&userid=27126
View this thread: http://www.excelforum.com/showthread...hreadid=469488