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:


    Code
    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?


    TIA,


    Far Farley

    Re: Local Settings Overriding Savechanges:=false


    Have you tried turning DisplayAlerts off?


    Code
    Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True



    Mac

    Re: Local Settings Overriding Savechanges:=false


    Macro,


    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.


    Far

Participate now!

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

Register Yourself Login