How to open a workbook on a specific worksheet.

[kevincanuk]

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


Thanks Kevin

 

[Dave Peterson]

Option Explicit
Sub autpen()
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]

Thanks very much Dave ...Works Great!!

Option Explicit
Sub autpen()
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