Forum Discussion

andrewmartin's avatar
andrewmartin
Copper Contributor
Aug 20, 2023
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...
admin
excel
office 365
training
  • HansVogelaar's avatar
    HansVogelaar
    Aug 20, 2023

    andrewmartin 

    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 Sub

    You'll have to save the workbook as a macro-enabled workbook (*.xlsm) and allow macros when you open it.

andrewmartin's avatar
andrewmartin
Copper Contributor
Aug 20, 2023

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.

HansVogelaar's avatar
HansVogelaar
MVP
Aug 20, 2023

andrewmartin 

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 Sub

You'll have to save the workbook as a macro-enabled workbook (*.xlsm) and allow macros when you open it.

Resources