+ Reply to Thread
Results 1 to 8 of 8

have Excel 2013 automatically open as maximized window

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Canada
    MS-Off Ver
    Office 2013 Pro
    Posts
    3

    Question have Excel 2013 automatically open as maximized window

    How do you get Excel 2013 to automatically open up in a maximized window?

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: have Excel 2013 automatically open as maximized window

    Hi,

    You can select the Maximized option from Run.
    Please check the picture for your reference.

    Regards,
    AM
    Attached Images Attached Images
    Last edited by ashishmehra2010; 12-27-2014 at 12:52 AM.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: have Excel 2013 automatically open as maximized window

    Hi bhamilton and welcome to the forum,

    It looks like Excel will open the same way it was when closed the last time it was used.

    One of these two VBA lines might get what you want.

    Application.DisplayFullScreen = True
    Application.WindowState =xlMaximized

    You would need to put these lines on an Event macro for when Excel or a workbook is opened.

    http://www.cpearson.com/excel/Events.aspx Explains lots about VBA and Events.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: have Excel 2013 automatically open as maximized window

    Hi MarvinP,

    In reply to
    Please Login or Register  to view this content.
    Can you please check the Properties of Excel & change the normal window option to Maximized (refer to attached picture in comment# 2)

    Regards,
    AM

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: have Excel 2013 automatically open as maximized window

    Hi AM,

    I can't see or open your attached graphic above.

  6. #6
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: have Excel 2013 automatically open as maximized window

    Hi MarvinP,

    Check the properties of Excel & select Shortcut tab. Select Maximized option.
    refer to this link
    http://blogmines.com/blog/how-to-aut...imized-window/

    Regards,
    AM
    Attached Images Attached Images

  7. #7
    Registered User
    Join Date
    12-27-2014
    Location
    Canada
    MS-Off Ver
    Office 2013 Pro
    Posts
    3

    Re: have Excel 2013 automatically open as maximized window

    tried that and it opens Excel in the state I last exited Excel. When I do not exit Excel with the window maximized, it doesn't maximize the window when I start Excel.

  8. #8
    Registered User
    Join Date
    12-27-2014
    Location
    Canada
    MS-Off Ver
    Office 2013 Pro
    Posts
    3

    Re: have Excel 2013 automatically open as maximized window

    Quote Originally Posted by MarvinP View Post
    Hi bhamilton and welcome to the forum,

    It looks like Excel will open the same way it was when closed the last time it was used.

    One of these two VBA lines might get what you want.

    Application.DisplayFullScreen = True
    Application.WindowState =xlMaximized

    You would need to put these lines on an Event macro for when Excel or a workbook is opened.

    http://www.cpearson.com/excel/Events.aspx Explains lots about VBA and Events.
    I did read that somewhere but couldn't figure out how to or where I should add those lines of code. I'm not sure if I will have to add that code to every Excel file I create or if it effects any Excel file that is created or will be created.

+ 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. Replies: 7
    Last Post: 02-26-2021, 01:46 AM
  2. Open a file in non-maximized window?
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2014, 08:40 AM
  3. File open maximized in excel window
    By Mr. F in forum Excel General
    Replies: 1
    Last Post: 12-26-2012, 04:39 AM
  4. Excel Window Not Maximized
    By yawnzzzz in forum Excel General
    Replies: 2
    Last Post: 02-03-2011, 02:12 PM
  5. [SOLVED] Excel window not maximized on start
    By Hennie in forum Excel General
    Replies: 1
    Last Post: 07-25-2005, 01:05 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