Microsoft Office Tutorials and References
In Depth Information
A setting that requires a macro
check box in the Display Options for This Worksheet section of the Advanced tab in the
Excel Options dialog box.
h Zero Values: Sometimes, you may prefer to hide all zero cells and show a blank cell
instead. Control this option by using the Show a Zero in Cells That Have Zero Value check
box in the Display Options For This Worksheet section of the Advanced tab in the Excel
Options dialog box.
h Scroll Bars: You can hide the horizontal and vertical scroll bars for a workbook. Go to the
Display Options for This Workbook section on the Advanced tab of the Excel Options
dialog box and use the two check boxes labeled Show Horizontal Scroll Bar and Show
Vertical Scroll Bar.
h Sheet Tabs: To hide the sheet tab, go to the Display Options for This Workbook section
on the Advanced tab of the Excel Options dialog box and remove the checkmark from
the Show Sheet Tabs check box. With no sheet tabs, you can use Ctrl+PgUp and
Ctrl+PgDn to activate a different sheet.
A setting that requires a macro
Turning off the display of one user interface element requires a macro.
The status bar, at the bottom of the Excel window, displays a variety of information. In versions
prior to Excel 2007, the user could turn the status bar display on or off. Now, a VBA macro is
required to toggle the status bar display:
Sub ToggleStatusBar()
With Application
.DisplayStatusBar = Not .DisplayStatusBar
End With
End Sub
 
Search JabSto ::




Custom Search