Close on specific worksheet before save

Hi,

I've seen the code to open a workbook on a specific worksheet, but can this be done when closing. I tried:

Private Sub Workbook_Close()
  Sheets("Sheet1").Activate
End Sub

but no luck. I want the document to navigate to a specific worksheet when closed so is saved there. So when the user closes and clicks yes to save it moves before the save. Is that possible? I don't mind if the workbook must be saved everytime it closes...

Thanks,
Joe