ExcelBanter - Open to tab

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Open to tab (https://www.excelbanter.com/excel-discussion-misc-queries/131259-open-tab.html)

Pietro

Open to tab

Hi ,
I have an Excel sheet with many tabs..
What should i do to oblige MS Excel to open a certain tab whenever i open
this MS excel sheet ?

Thanx for your help

JE McGimpsey

Open to tab

Put this in your ThisWorkbook code module:

Private Sub Workbook_Open()
Application.GoTo Sheets("Certain_Tab").Range("A1")
End Sub

In article ,
Pietro wrote:

Hi ,
I have an Excel sheet with many tabs..
What should i do to oblige MS Excel to open a certain tab whenever i open
this MS excel sheet ?

Thanx for your help

All times are GMT +1. The time now is 05:22 PM.