Opening in Full Screen.

[skrol]

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

 

[bigwheel]

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/default.asp?url=/archive/en-us/dnaro97ta/html/ofcmdbar.asp for guidance

 

[bigwheel]

Oops, the Microsoft article was specific to Access but the principle is the
same ...
Try
http://msdn.microsoft.com/library/d...ml/deovrworkingwithsharedofficecomponents.asp

 

[skrol]

Thanks BigWheel,

That helped me a lot.
The only thing that's I'm missing ans needing in FullScreen are the
worksheet tabs.
I'm rather good in JScript, but new to VBScript.
I'm in a hurry to get this workbook done, so I don't have to much time
to study Macro's etc.
Maybe you, or some one else, have a solution how to include the tabs in
this fullscreen.

Something like: -Application.DisplayTabBar (???) = True-


Where can I find something about these "instructions" ?

Again, thanks a lot.

S.Krol

 

[skrol]

Hi again,
Actually, I found a solution for the tabs on this forum:

http://www.excelforum.com/archive/index.php/t-228810.html

Including: "Application.DisplayStatusBar = True" , now shows the uppe
part of the tabs and the horizontal scrollbar. Just a littlebit.
I think that wat is happening:

The tabs and the horizontal scrollbar were already there, but becaus
it's really "FullScreen", they were hidden behind the main windows bar
were you can see the opened programs, time etc.
Now including the StatusBar, makes that the tabs/h.scrollbar are goin
just "higher" on the screen, making them (in my case) more or les
visible.

Getting There,
How to make "FullScreen" just go to that Windows Mainbar ??

:confused