MrExcel Publishing
Your One Stop for Excel Tips & Solutions

user interface


Posted by Graham on February 10, 2002 5:59 AM

How do I get excel to display the worksheets only without any thing else like worksheet menu bar etc?


Posted by Zzyzzyth on February 10, 2002 12:18 PM


Under Tools> Options> Views you can turn off the status bar, formula bar, and Row/Column headings

Posted by Sam S on February 11, 2002 3:06 AM

Try the following

Sub Auto_open()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollbar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With

Application.DisplayFormulaBar = False
Application.CommandBars("Standard").Visible = False
repeat for any other toolbars you want

Sheets("Sheet1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

This will remove Row & column headers, scrollbars and worksheet tabs. Don't forget to restore all of these by replacing the False with True in a sub called auto_close()