Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Chigaru Massri   on Feb 12 In MS Office Category.

  
Question Answered By: Judy Gray   on Feb 12

I removed the "Application.Quit" in the Auto_Close subroutine.
I coded it as follows:
Application.DisplayAlerts = False
ActiveWorkbook.Saved = True
ActiveWorkbook.Close( 0 )

Now, there are no prompts when exiting the Excel file  and all of Excel is not
shutdown.
I think the above is safer and better than having the Application.Quit
I am not sure how one would use the Application.Quit

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Auto_Close Or get search suggestion and latest updates.


Tagged: