Windows( Worksheet In Basis (1) ).Activate. Activate a worksheet on opening. Get the second worksheet from the workbook.
Or 2, a much better solution is: 3.in the split data into multiple worksheets dialog box, you need to:. If you want to activate a specific worksheet every time when you open the workbook then you name that vba code auto_open.