Search notes:

Excel Object Model: WorksheetView

The WorksheetView object controls «Look and Feel» settings.

Obtaining an instance of a worksheetView object

An instance of a 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* properties

The interesting properites start with 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
Compare with the display* properties of the Application object and the display* options of the window object.

See also

SheetViews
Excel Object Model

Index