View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
owp^3 owp^3 is offline
external usenet poster
 
Posts: 8
Default BeforeClose order of events?

Ok, I understand that I can skip the "Do you want to save..." warning by
setting ThisWorkbook.Saved = True.

And I understand I can abort the Close by setting Cancel = True.

I need a better understanding of the order in which things occur because...

I Show a "Goodbye" Userform with a timer from the BeforeClose Event but it
gets covered up by the "Do you want to save..." warning. I would like it to
show only after the user has responded to the warning or if there is no
warning.

I could make it bigger so the user can read it behind the warning but I
really would like there to be only one userform/dialog at a time.

Any ideas?

Thanks,
owp^3