how do I set the tab that my workbook opens with
 

I notice that on a multi tab workbook sometimes a spreadsheet
consistently opens with a certain tab. How do you set that to happen?

how do I set the tab that my workbook opens with
 

I've always last saved in the tab I want opened next time. It should save
your last position/tab after every save.

"Joe" wrote:

I notice that on a multi tab workbook sometimes a spreadsheet
consistently opens with a certain tab. How do you set that to happen?

how do I set the tab that my workbook opens with
 

You could just put it in an Auto_Open macro:

Sub Auto_Open()

Sheets("Your Sheet Name").Select

End Sub


"Joe" wrote:

I notice that on a multi tab workbook sometimes a spreadsheet
consistently opens with a certain tab. How do you set that to happen?