• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

saving file

Shabbo

Member
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?
 
Place in your workbook events

Code:
Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save
End Sub
 
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!!
 
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.
 

Attachments

  • Capture.JPG
    Capture.JPG
    89.6 KB · Views: 1
Back
Top