How to open a workbook on a specific worksheet.
 

Can anyone show me how to have a multiple page workbook always open to the
same worksheet. (Splash Page)


Thanks Kevin

How to open a workbook on a specific worksheet.
 

Option Explicit
Sub auto_Open()
worksheets("splashSheet").select
end sub

Change the worksheet name to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

kevincanuk wrote:

Can anyone show me how to have a multiple page workbook always open to the
same worksheet. (Splash Page)

Thanks Kevin

--

Dave Peterson

How to open a workbook on a specific worksheet.
 

Thanks very much Dave ...Works Great!!

"Dave Peterson" wrote:

Option Explicit
Sub auto_Open()
worksheets("splashSheet").select
end sub

Change the worksheet name to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

kevincanuk wrote:

Can anyone show me how to have a multiple page workbook always open to the
same worksheet. (Splash Page)

Thanks Kevin

--

Dave Peterson