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

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

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