Forum Discussion
Solved
Can I save a workbook in split screen view?
I'm using Excel in MS 365. An AI is telling me I can save my workbook in split screen view. However, its instructions to: In the Save As dialog box, click the More Options button. In the Ad...
I'm not aware of a built-in way to do that. You might create the following code in the ThisWorkbook module in the Visual Basic Editor:
Private Sub Workbook_Open() Me.Windows.Arrange ArrangeStyle:=xlVertical End SubYou'll have to save the workbook as a macro-enabled workbook (*.xlsm) and allow macros when you open it.
AI recommendations are not always reliable, to put it mildly.
Do you meant that split the window into 2 or 4 panes from the View tab of the ribbon? If so, Excel will automatically save that setting with the workbook, you don't need to do anything extra.
Or do you mean something else?
HansVogelaar Not quite. I'm using the New window/arrange all buttons to so I can view two worksheets side by side. I'd like the saved file to open as two worksheets being viewed side by side too.
I'm not aware of a built-in way to do that. You might create the following code in the ThisWorkbook module in the Visual Basic Editor:
Private Sub Workbook_Open() Me.Windows.Arrange ArrangeStyle:=xlVertical End SubYou'll have to save the workbook as a macro-enabled workbook (*.xlsm) and allow macros when you open it.
