View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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