Hiding

Location: http://www.mvps.org/dmcritchie/excel/hiding.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

Things on this page can be typically be found in Google Groups search for hiding group:*excel*

Hiding Formulas

Formulas can be hidden with Cell Protection: Format, Cells, Protection(tab), [x] Hidden

Format, rows, hide/unhide
Format, colum,ns, hide/unhide
include other menu and customization options

   Application.DisplayAlerts = False
   ActiveWorkbook.Save
   Application.DisplayAlerts = True

   ActiveWindow.Caption = ""

Tools, Options, View tab, then uncheck sheet tabs, optionally Row and Column headers. in the section "Window Options"

   With ActiveWindow
      .DisplayHeadings = False
      .DisplayWorkbookTabs = False
   End With

Full Screen Mode, occupies entire screen, only the menu bar is visible but other could be made visible. Caused with View, Fullscreen. Can be returned to normal even if the Full Screen button is not shown on the worksheet with View, Normal (or by redoing View, Fullscreen).

This page was introduced on March 6, 2002.

Please send your comments concerning this web page to: David McRitchie send email comments