Close on specific worksheet before save

**tuckjoseph** · 01-26-2010, 01:03 PM

Hi,

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

Please Login or Register  to view this content.

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** · 01-26-2010, 01:06 PM

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

**shg** · 01-26-2010, 01:39 PM

The event signature is

Please Login or Register  to view this content.

**tuckjoseph** · 02-01-2010, 09:01 AM

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