Direct to specify worksheet when open a file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any idea how to direct to a specify worksheet when open a file.
Example I have 5 sheets on workbook1. When open the file it show sheet no.3 first.
Thanks
 
Hi
you have to use VBA for this. e.g. put the following code in your
workbook module (not in an standard module):
sub workbook_open()
me.worksheets("sheet3").activate
end sub
 
Back
Top