Full Screen

RichieF · Apr 25th, 2002, 02:53 AM

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.

Tom Schreiner · Apr 25th, 2002, 03:09 AM

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.

Quote:

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

Tom

Ivan F Moala · Apr 25th, 2002, 03:16 AM

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 · Apr 25th, 2002, 03:17 AM

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 · Apr 25th, 2002, 03:45 AM

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.

Tom Schreiner · Apr 25th, 2002, 05:34 AM

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 ]

Apr 25th, 2002, 03:16 AM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	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 __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 02:53 AM	#1
RichieF New Member Join Date: Apr 2002 Posts: 20	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.

Apr 25th, 2002, 03:17 AM	#4
RichieF New Member Join Date: Apr 2002 Posts: 20	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 ?

Apr 25th, 2002, 03:45 AM	#5
RichieF New Member Join Date: Apr 2002 Posts: 20	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.

Apr 25th, 2002, 05:34 AM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]