Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confusion about how the Window object fits into the Excel object model
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Object Model | Excel Programming | |||
Excel 2003 object model | Excel Programming | |||
Excel object model | Excel Programming | |||
Docs for Excel object model with p/e/m | Excel Programming | |||
Subtotals in Excel object model | Excel Programming |