Workbook Window Size RRS feed

  • Question

  • Assume I have several workbooks, some visible some not. One window for each WB to simplify.

    I want to resize each of them with a specific size.

    With the Workbook.Windows(1) property I can get access to and modify window size and position WHEN THE WINDOW IS IN THE STATE xlWindowStateNormal.

    If the window is minimized or hidden I cannot do this (Excel 2015, floating windows). In this case I can set windowstate to normal, set the window size and then set back to minimized or hidden. This induces screen flashing as window pops up and close.

    So the question is : is there a way to modify Window position and size for hidden or minimized windows without opening them ?

    Sunday, February 28, 2016 1:01 PM