Prompt for saving a saved workbook

  • Thread starter Thread starter Mats Samuelsson
  • Start date Start date
M

Mats Samuelsson

Suddenly when quitting my application and running the
save & close procedure Excel asks if I want to save the workbook at the
Application.quit command, spite it was already done?
Anyone knows what is causing this?
Dim WB as Workbook
For Each WB In Application.Workbooks
WB.Save
Next WB
Application.Quit
 
Is there perhaps something in your "Workbook_BeforeClose" procedure that is
making a change and therefore triggering the Save/Not Save question? Or
maybe a Worksheet event making a change?
 
Back
Top