Josephine,
Assuming you are using something like:
Set MyWB=Workbooks.Open(PathAndFilename)
add a line:
MyWB.Worksheets(1).Activate
......

NickHK

"Josephine Ng" <Josephine wrote in message
...
Please advise what visual basic code I need to use to always open my file
showing the first worksheet even though I save the file at 2nd or 3rd
worksheets.