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

Hiding Rows, Hiding Columns

Format, rows, hide/unhide
Format, colum,ns, hide/unhide

include other menu and customization options

Hiding Save Prompts

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

Hiding Title Bar

   ActiveWindow.Caption = ""  

Hiding Worksheet Tabs

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

VBA coding

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

Hidden things that look like problems if unexpected

Related


This page was introduced on March 6, 2002. 

[My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
[Site Search -- Excel]     [Go Back]    [Return to TOP

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


Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved