how do I set the tab that my workbook opens with

J

Joe

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

M Scott

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

RCW

You could just put it in an Auto_Open macro:

Sub Auto_Open()

Sheets("Your Sheet Name").Select

End Sub
 
Top