+ Reply to Thread
Results 1 to 2 of 2

Open Workbook in "Full Screen" mode but with sized "Window" View

  1. #1
    Registered User
    Join Date
    09-01-2015
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Pro Plus 2010
    Posts
    33

    Open Workbook in "Full Screen" mode but with sized "Window" View

    Hi all,

    I don't really know how to "explain" my problem, except without a picture.
    I'm trying to build a VBA code so that my workbook opens in a window view, but with full screen "properties".

    I have attached a screenshot of what I want to see when the workbook opens.
    I will also build in the relevant "Workbook_Before_Close" script so that Excel returns to normal, for regular use.
    Just for added info, I also have code that "sizes" the contents of each Worksheet by:

    Please Login or Register  to view this content.
    Can anybody assist with some code so that I can get this thing to open in the view that I need? See the attached.
    Thanks.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    09-01-2015
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Pro Plus 2010
    Posts
    33

    Re: Open Workbook in "Full Screen" mode but with sized "Window" View

    So after extensive research with the aid of Mister Google, I managed to solve my own problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Activating unsaved open workbook using "if "name" like "name" satement
    By joshuarobbins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2015, 11:17 AM
  2. [SOLVED] FORCE Excel to stay in "Full Screen" mode
    By ericbartha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2015, 02:19 PM
  3. Replies: 1
    Last Post: 05-23-2013, 02:04 PM
  4. Macro to open a "Protected View" workbook and enabling edit
    By WaqasTariq in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2013, 05:25 PM
  5. VBA - IE - click on "Open" in an internet explorer "file download" window
    By victoire in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 07:08 AM
  6. Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook
    By JingleRock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2006, 12:10 AM
  7. Replies: 0
    Last Post: 01-04-2006, 06:55 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