Make Default Sheet in Excel

There are times when you want a certain sheet in Excel to open up everytime you want to open excel.

Well, you're problem is solved my friend with a few codings, you can make a certain sheet your default sheet.

Just follow this simple steps:

1. Right click the tab of the sheet you wish to be your default sheet.

(Image when tab is right clicked)

2. Click/Choose View Code

3. Visual Basic for Application will now be displayed on screen.

4. Double click "ThisWorkbook"

5. Code Editor Window opens

6. In between Private Sub Workbook_Open() and End Sub, enter the following code:

Sheets("nameofmysheet").Activate

Where "nameofmysheet" is the name of the sheet/tab you wish to be displayed first. By

default, the sheet/tab is named "Sheet1".

That's all for making a certain sheet your default sheet in MS Excel.

Hope this helps folks,

Till next tutorial.

See you then...