How to use command buttons on a splash screen in MS-Excel

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010

Home

How can I create buttons on a splash screen that take you to another sheet in the workbook? When I reach the next worksheet I do not wish to see the column and row header numbers and the horizontal and vertical scrollbars. How do I achieve this? How can I exit the workbook with a single click?

We use two command buttons with the following VBA code to solve this problem:
 
Private Sub CommandButton1_Click()
Sheets("sheet2").Select
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
End Sub

Private Sub CommandButton2_Click()
ThisWorkbook.Close
End Sub

You can also rename the command buttons appropriately by right-clicking on them and edting their properties.

Watch the video below to see how to use command buttons on a splash screen in MS-Excel




Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010