Options¦View

Home Search Site Map

Up
Options¦Calculation
Options¦Chart
Options¦Color
Options¦Custom Lists
Options¦Edit
Options¦Error Checking
Options¦General
Options¦International
Options¦Save
Options¦Security
Options¦Spelling
Options¦Transitions
Options¦View

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

UK EXCEL USER CONFERENCE - LONDON, UK. APRIL 1st/2nd 2009 - TOTALLY FREE - DETAILS CAN BE CHECKED OUT HERE! Check It Out!


Menu command Type What happens next?
View Tab

Broken down into the four sub-sections, this tab sets all the items that can be seen, (or not) in Excel.

  1. Show
    Start-up task pane is the pane on the right that starts up with excel offering the options of 'New workbook, existing files, templates, etc. 'Formula bar' can remove it from display and likewise 'status bar'. (The bar at the base of the Excel application that generally has 'ready' in the left corner). 'Windows in taskbar' allows you to have each Excel file you open listed as a separate file on Windows taskbar.
  2. Comments
    Sets how comments are displayed in Excel, nothing shown, indicator only. (red triangle) or indicator and full comment
  3. Objects
    Whether objects, such as pictures are shown in full, just a placeholder so you know they are there or not show at all.
  4. Window options
    Checking or un-checking these is fairly self-explanitory. The gridline colour can be set, but please bear in mind any gridline is removed when you apply a fill to a cell(s) and you will need to use borders to simulate gridlines.
VBA Sub setViewOptions()
With Application
.ShowStartupDialog = False
.DisplayFormulaBar = False
.DisplayStatusBar = False
.DisplayCommentIndicator = xlNoIndicator
.ShowWindowsInTaskbar = False
End With
With ActiveWindow
.DisplayFormulas = True
.DisplayGridlines = False
.GridlineColorIndex = 3
.DisplayHeadings = False
.DisplayOutline = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
ActiveSheet.DisplayAutomaticPageBreaks = True
ActiveWorkbook.DisplayDrawingObjects = xlPlaceholders
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.