Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Full Screen

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •