Close on specific worksheet before save

[tuckjoseph]

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

[StephenR]

What's the point if you're closing the file?

[shg]

The event signature is

Private Sub Workbook_BeforeClose(Cancel As Boolean)

[tuckjoseph]

That works great, thanks shg.

I want this for aesthetic reasons, so when a user opens the workbook the worksheet it was last saved on (if not the desired one) doesn't flash up or appear behind an initial alert boxes (update, macros etc).

Thanks again

Joe