Opening to a default tab?

[Joe]

Hello,

Is there a way to get a workbook to default to a certain tab when opening
the file? I noticed that it opens to whatever page was open when last saved
but I want it to always open to the first sheet regardless. Any ideas?

Thank you in advance,
Joe

 

[Don Guillett]

Use the Workbook_open event in ThisWorkbook module or an auto_open macro in
a regular module
sub auto_open()
sheets("mysheet").select
end sub

 

[Joe]

Thanks guys, worked like a charm!

 

[Don Guillett]

glad to help