| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
Linear Mode
