ExcelBanter - Startup Tab

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Startup Tab (https://www.excelbanter.com/excel-programming/411037-startup-tab.html)

Larry S

Startup Tab

Is there a way to specify which tab is active when a workbook opens? I'd like
to have one of our custom tabs be the active tab.

Thanks, Larry

Mike H

Startup Tab

Hi,

Alt + f11 to open VB editor. Ctrl+R to open project explorer, double click
'This Workbook' and paste this in on the right. Change the sheet name to suit

Private Sub Workbook_Open()
Sheets("Sheet3").Select
End Sub

Mike

"Larry S" wrote:

Is there a way to specify which tab is active when a workbook opens? I'd like
to have one of our custom tabs be the active tab.

Thanks, Larry

Larry S

Startup Tab

I was talking about the tabs on the ribbon, not sheet tabs.

"Mike H" wrote:

Hi,

Alt + f11 to open VB editor. Ctrl+R to open project explorer, double click
'This Workbook' and paste this in on the right. Change the sheet name to suit

Private Sub Workbook_Open()
Sheets("Sheet3").Select
End Sub

Mike

"Larry S" wrote:

Is there a way to specify which tab is active when a workbook opens? I'd like
to have one of our custom tabs be the active tab.

Thanks, Larry

All times are GMT +1. The time now is 09:42 AM.