WorksheetView object controls «Look and Feel» settings. worksheetView object is obtained via the window object: activeWorkbook.windows(1).activeSheetView.displayGridlines = false
activeWorkbook.windows(1).sheetViews("lcfw").displayFormulas = false
activeWorkbook.windows(1).sheetViews(activeSheet.name).displayFormulas = false
activeWindow.activeSheetView.displayGridlines = false
… etc etc …
Display*: DisplayFormulas | display or hide formulas. The Ribbon equivalent is Formulas -> Formula Auditing -> Show Formulas. Not the same thing as application.displayFormulaBar. |
DisplayGridlines | show or hide gridlines. In the ribbon, gridlines can be shown using the corresponding option under View -> Show |
DisplayHeadings | show or hide headings. In the ribbon, gridlines can be shown using the corresponding option under View -> Show |
DisplayOutline | |
DisplayZeros |
thisWorkbook.windows(1).sheetViews(1).displayFormulas = true
display* properties of the Application object and the display* options of the window object.