Full Screen

Home Search Site Map

Up
Comments
Custom Views...
Formula Bar
Full Screen
Header & Footer...
Normal
Page Break Preview
Status Bar
Task Pane
Toolbars
Zoom...

New! Excel User Group Now Open @ www.excelusergroup.org,

Menu command Type What happens next?
Full Screen  

Places Excel into 'Full screen' mode which hides all toolbars, except the worksheet menu bar, the formula bar and the status bar. You can use this mode when you want to display the most possible amount of data, or wish to avoid the confusion of toolbars being visible, etc.  This mode is great for presentations. The 'Full screen' toolbar, (below), should launch by default,

although you can return to the 'view' menu to toggle this view off.

Sub DisplayFullScreen()
With Application
'check if full screen mode is on
If .DisplayFullScreen = True Then
'if on, turn off
.DisplayFullScreen = False
Else
'if off, turn on
.DisplayFullScreen = True
End IfIf
End With
End Sub

 

Copyright Nick Hodge 2009. All Rights Reserved.