Create Excel Spreed Sheet file which no need press Ctrl+S or F12 for Save after edit .follow the Step

1. Creating Your First Spreadsheet

2. Save your file with macro-enabled .XLSM extension.

3. Press Alt+F11

4. Then Right click on ThisWorkbook and open view code

5.Then copy the code and paste or type same code on white Screen then save and exit

Private Sub Workbook_BeforeClose(Cancel As Boolean)

ThisWorkbook.Save

End Sub

6.Now you can use your favorite Excel file which auto Save withour Ctrl+S.

Comments