Search notes:
Excel: View -> Show
The Menu
View -> Show
can be used to show or some elements on the GUI. The right column shows how these elements can be manipulated with
Excel's object model
:
Comments
Object model
Ruler
Only applicable in
Page Layout mode
?
Formula Bar
application.displayFormulaBar
Gridlines
worksheetView.displayGridlines
Headings
Show/hide column numbers and row letters
worksheetView.displayHeadings
Note:
Ruler
,
Gridlines
and
Headings
change the setting for the active
window
only while
Formula Bar
sets it «globally».
Index