Hi Josh,

This might give an idea of what's going on:

Sub Test()
Dim i As Long
Dim wb As Workbook
Dim ws As Worksheet
Dim w As Window

Set wb = Workbooks.Add
Set w = wb.NewWindow

wb.Windows(1).DisplayGridlines = False

wb.Windows(2).Activate
wb.Worksheets(2).Activate
wb.Windows(1).DisplayGridlines = False

'ThisWorkbook.Activate
wb.Windows(2).Activate
For i = 1 To 2
wb.Windows(i).Activate
For Each ws In wb.Worksheets
ws.Activate
Debug.Print wb.ActiveSheet.Name, _
"Window-" & i, wb.Windows(1).DisplayGridlines
Next
Debug.Print
Next

End Sub

You should find you can apply different settings to the same sheet in
different windows.
Note Window(1) is the active window of the WB, regardless of how many
windows it has or if the WB itself is active.

But there's something rather strange about the WB/Windows collection, eg
it's possible to run two different customized palettes in the same WB
(there's a bit of a nack to doing that ! ).

Regards,
Peter T

"Josh Sale" <jsale@tril dot cod wrote in message
...
I'm a bit confused about how the Window object fits into the Excel object
model and am hoping somebody can set me straight. Here's my deal ...

My application wants to create a new worksheet and have its gridlines and
headings be set the same as another worksheet in a different workbook. I
understand that the DisplayGridlines and DisplayHeadings properties are
part
of the Window object and not the worksheet object. In fact if you search
through all of the properties of a workbook and its constituent parts you
can't find anything that controls these two apparent aspects of the
worksheet.

Yet, if you go to Tools | Options and check or uncheck these properties to
change the appearance of the currently active worksheet, save the workbook
(which presumably doesn't save the active window) and then reopen the
workbook, the gridlines and headings are restored to their state at the
time
of the save.

So presumably, these properties of the window are being saved with the
workbook? But where? What am I missing?

It bugs me to have this gap in my mental model of how Excel is strung
together. Again I hope somebody will set me straight on how this hangs
together.

TIA,

josh