Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to make Excel open in a specific worksheet
Hello,
Just a quick one. Does anyone know what the VB code is to make Excel open a workbook with a specific worksheet selected? thanks, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to make Excel open in a specific worksheet
Hi
you could put the following code in the workbook_open event of this file: sub workbook_open() me.worksheets("sheet2").activate end sub -- Regards Frank Kabel Frankfurt, Germany "OscarC" schrieb im Newsbeitrag ... Hello, Just a quick one. Does anyone know what the VB code is to make Excel open a workbook with a specific worksheet selected? thanks, Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to make Excel open in a specific worksheet
Michael,
In the target workbook, add this code to the ThisWorkbook code module Private Sub Workbook_Open() Thisworkbook.Worksheets("Sheet3").Activate End Sub change the Sheet3 to your name -- HTH RP (remove nothere from the email address if mailing direct) "OscarC" wrote in message ... Hello, Just a quick one. Does anyone know what the VB code is to make Excel open a workbook with a specific worksheet selected? thanks, Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make Excel display a specific worksheet? | Excel Discussion (Misc queries) | |||
Is there a way to open an excel file to a specific worksheet? | Excel Discussion (Misc queries) | |||
I need a shortcut to make a excel file open to a specific sheet | Excel Discussion (Misc queries) | |||
How do you open a specific worksheet using an Excel Driver? | Excel Programming | |||
VBA code to open a specific worksheet | Excel Programming |