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*
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
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"
.DisplayHeadings = False
.DisplayWorkbookTabs = False
Hidden things that look like problems if unexpected
- 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.
[My Excel Pages -- home]
[INDEX to my site and the off-site pages I reference]
[Site Search -- Excel]
[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