Local Settings Overriding Savechanges:=false

  • I have an Excel 2003 application that automatically opens and closes a lot of workbooks.

    When done with a workbook, I close it with:

    ActiveWorkbook.Close SaveChanges:=False

    On most users' machines, this works well.

    On one user's machine, the procedure is still asking:

    " Do you want to save the changes you made to 'filename'? "

    at each workbook close. Considering that a typical run might inspect over 2,000 workbooks, this is a problem for the user.

    Is there a setting that can override "SaveChanges:=False"?

    If so, where would I find it, and how would I programmatically turn it on/off?


    Far Farley

  • Re: Local Settings Overriding Savechanges:=false

    Have you tried turning DisplayAlerts off?

    Application.DisplayAlerts = False
    Application.DisplayAlerts = True


  • Re: Local Settings Overriding Savechanges:=false


    Thanks for the reply.

    Yes, trying that was my last gasp try before I posted. Excel still presents the safety switch, even with DisplayAlerts = False.

    The trick seems to be that the problem is machine dependent (works correctly on most machines, but not on the Project manager's machine. Sweet, huh?).

    We went through Tools | Options tab-by-tab and didn't find anything.

    I can see it now... it will be some arcane registry setting that cannot be modified from within Excel.

    If you (or anyone else) have any other strategies to try, they would be appreciated.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!