Full Screen

[RichieF]

I'm trying to set up an excel file so that when opened it opens in Full Screen mode.
I don't want this for all files, just one specific one.
Is there any (simple) way of doing this ?

Cheers.

 

[Legacy 98055]

Hi
Right-Click on the Excel icon in the upperleft of your screen(Directly left of the File menu item) and choose view code.

Paste the following code into the new window.
Save your workbook, close, reopen.

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub

Tom

 

[Ivan F Moala]

and just for completeness
do the same in reverse so the screen is
reset back upon closing ie.

Private sub Workbook_beforeclose()
Application.displayfullscreen=false
end sub

 

[RichieF]

Genius !! Thanks Tom.

Would love to find out more about this 'code' !! Can you recommend any web sites and/or books which give more examples of stuff like this that I can use in my spreadsheets ?

 

[RichieF]

Ivan

I've tried pasting your code (to reset screen on closing) below the other code, but I get an error message.

Am I doing something wrong ??!!! Thanks.

 

[Legacy 98055]

Hi Richie
This site here is an excellent source.
The first thing I would master is learning how to find what you need. VB/VBA is not really about memorizing keywords or syntax, but about learning how to develop or build an application by using objects. You can know the reference 'till your blue in the face, but someone who understands object-based architecture can build just about anything. Learn how to build your app and have fun doing it.

1. Help system files
2. Record Macros and see what the code does.
3. Find better ways to accomplish your tasks on boards such as these from people who use the stuff in the real world. Better than books, I think.
4. Nothing against books, they are great.
Tom
This message was edited by TsTom on 2002-04-25 04:36