Results 1 to 2 of 2

Open workbook in full screen mode

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2013
    Location
    Vancouver
    MS-Off Ver
    Excel 2010
    Posts
    1

    Open workbook in full screen mode

    Hi everyone,
    I'll like a particular workbook to open in Full Screen Mode, and also to disable ESC from exiting full screen.
    I'm using code below, but when I open other workbooks, they also open in Full Screen. I only would like a particular workbook to open in Full Screen, not all workbooks.
    Also, when I minimize Excel and then go back to the workbook, it is not full screen anymore. I would like it to be on full screen even if I minimize Excel.

    Thank you

    Private Sub Workbook_Activate()
    On Error Resume Next
        With Application
            .DisplayFullScreen = True
            .CommandBars("Worksheet Menu Bar").Enabled = False
        End With
    Application.OnKey "{ESC}", ""
    Application.EnableCancelKey = xlDisabled
    End Sub
    Last edited by V_A; 11-29-2013 at 02:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Prevent ESC from Full Screen Mode
    By Orson100 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-19-2017, 05:03 AM
  2. Print preview options and full screen mode
    By shirleyxls in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 11:54 AM
  3. toggle to turn full screen mode on and off via onkey shortcut
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2010, 02:54 PM
  4. Open Workbook in Full Screen Mode
    By manny_cb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2008, 04:53 PM
  5. Disable right mouse click when in Full screen mode
    By clayton in forum Excel General
    Replies: 2
    Last Post: 03-21-2006, 10:53 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1