How do I set up a file to automatically save on exit?
in [General]
|
Prev: copy rows from one Data sheet to another sheet based on cell c
Next: linking worksheets in Excel 2007
From: Brian on 15 May 2010 05:57 I have created a file that several users will be accessing with varying computer skill level. I want to be sure that the file saves automatically when they close the file out rather than having to answer "yes" to the "Do you want to save this file?" question. Can this be done?
From: Otto Moehrbach on 15 May 2010 11:34
Brian Yes, that can be done with VBA programming. The following macro will save the file whenever a close command is issued by the user, regardless of whether the file has already been saved. This is a Workbook event macro and must be placed in the workbook module. Post back and provide your Excel version if you need more help with this.. HTH Otto Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayAlerts = False ThisWorkbook.Save ThisWorkbook.Saved = True Application.DisplayAlerts = True End Sub "Brian" <Brian(a)discussions.microsoft.com> wrote in message news:91E5BD64-F3CA-4155-ABC2-E864FF8B6886(a)microsoft.com... > I have created a file that several users will be accessing with varying > computer skill level. I want to be sure that the file saves automatically > when they close the file out rather than having to answer "yes" to the "Do > you want to save this file?" question. Can this be done? |