saving file

[Shabbo]

Dear Sir,
My file doesn’t get save for last time I save.
When next day I open file I can’t see last entries.
Can you please suggest solution?

 

[AlanSidman]

Place in your workbook events

Option Explicit

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

 

[neeraj2050]

Hi, Could you please suggest the process of getting this code incorporated into excel

 

[AlanSidman]

Open you workbook. Click on Alt + F11. In the left window, click on the worksheet you wish the code to be in. In the right window that opens, paste the code I have provided. Save and close as an .xlsm file. Voila!!

 

[neeraj2050]

Thanks!! I did it, but nothing is being shown. I also pressed Alt+F8 but nothing is appeared

 

[AlanSidman]

oops! Instead of clicking on the worksheet in the left window, I should have told you to click on the "This Workbook" in the left window and then paste into the right window that appears. My apologies.