<div>
What you want is the WINDOW activate event<br />
<br />
e.g.,<br />
<br />
Private Sub Workbook_WindowActivate<br />
<br />
Dave
</div>


<div>
<div class="content wysiwyg-content">
In the View tab of the ribbon I create a New Window. &nbsp;This window opens with &quot;show gridlines&quot; selected by default.<br />
<br />
How can I make the new window &nbsp;DisplayGridlines=False?<br />
<br />
I tried this code in the worksheet VBA page but it doesn't execute since the worksheet is already selected when I create the new window.<br />
<br />
<br />
Private Sub Worksheet_Activate()<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;ActiveWindow.DisplayGridli<wbr />nes = False<br />
&nbsp; &nbsp; <br />
End Sub<br />

</div>
</div>


In the View tab of the ribbon I create a New Window.  This window opens with "show gridlines" selected by default.

How can I make the new window  DisplayGridlines=False?

I tried this code in the worksheet VBA page but it doesn't execute since the worksheet is already selected when I create the new window.


Private Sub Worksheet_Activate()

       ActiveWindow.DisplayGridlines = False
    
End Sub


Excel VBA - When creating a new window (so there are multiple windows), make new window  DisplayGridlines=False

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.