none
VBA code - the size of the screen in points RRS feed

  • Question

  • Hello,

    i am looking for the code, which define the size of screen.

    Or the code, which maximalize Excel workbook.


    VALL2

    Wednesday, June 19, 2013 10:56 AM

Answers

  • If you are only looking to maximize Excel and/or the active workbook's window try whichever you need of these

    ' maximize the Excel application
    Application.WindowState = xlMaximized
    ' maximize the active (workbook) window within Excel
    ActiveWindow.WindowState = xlMaximized

    If you want size of the screen post back and explain the objective

    Peter Thornton

    • Marked as answer by VALL2 Wednesday, June 19, 2013 11:11 AM
    Wednesday, June 19, 2013 11:10 AM
    Moderator