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

you could paste this into Thisworkbook mod

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

"Jens Palacios Neffke" wrote:

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

Thanks

"Mike" wrote:

you could paste this into Thisworkbook mod

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

"Jens Palacios Neffke" wrote:

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

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



"Jens Palacios Neffke" wrote:

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