Opening to a default tab?

J

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
 
D

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
 
Top