Automatically saving changes

  • Thread starter Jens Palacios Neffke
  • Start date
J

Jens Palacios Neffke

Hi

Is there any way to avoid clicking "Yes" every time at the "Do you want to
save the changes you made to XXXXXX.xls file?" dialog box? and setting this
option by default

Thanks
 
M

Mike

you could paste this into Thisworkbook mod

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub
 
C

challa prabhu

Do the following:

1. On the Tools menu, click Options.
The Option dialog box is diaplayed.
2. In the Options dialog box, click the Save tab.
3. Under Settings, select the Save AutoRecovery info every check box.
4. In the Save AutoRecovery info every text box, enter a numeric value in
minutes or click the arrow to select a time in minutes. It is recommended
that you specifiy the minimum value so that application automatically save
the workbook.
5. Click OK.

Challa Prabhu
 
Top