Skip to main content

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

Popular posts from this blog

Welcome to quick learning advance Excel

FORMULA OF SUM MIN MAX https://drive.google.com/open?id=11ZUSqVyJtO79YzDMeuQxfgOmwZxQ8G9d
VLOOKUP function performs a vertical lookup by searching for a value in the first column of a  table  and returning the value in the same row in the  index_number  position https://drive.google.com/file/d/1q2Kp-thQCnVQqnMT1K2X3ZuCMCvQ7pSL/view