AutoSave before close

  • Thread starter Thread starter mattsvai
  • Start date Start date
M

mattsvai

Is there any way to automatically save changes to an open excel sheet
using for example the beforeclose event trigger without prompting the
user?

Cheers
 
In the workbook's module BeforeClose even place a save command as illustrated
below:

======================================================
Private Sub Workbook_BeforeClose(Cancel As Boolean)

ActiveWorkbook.Save

End Sub
======================================================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Event after "Save changes?" prompt when exiting 1
Capture autosave/autorecover event 2
BeforeClose event won't run when closing using macro 1
Saving a variable value 3
Eliminate "Cancel" Button on Save/Close Event 2
Excell 2021 0
Delete a worksheet before closing workbook 4
WorkBook Deactivate Event 2

Back
Top