Always open to specified sheet in Excel

[aprunkard]

I know I have done this before but I have lost the sheet with the code in it...
I want my workbook to always open to "Start Here" sheet. I know it's simple.

Thanks!!

 

[TonyJollans]

Hi aprunkard,

You can code for this in the workbook open event. In the ThisWorkbook code module, add ..

Private Sub Workbook_Open()
    Sheets("Start Here").Activate
End Sub

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.