How To Automatically Save And Close Workbook After Inactivity In Excel

In this advanced excel tutorial i’ll show you how you can automatically save and close a workbook after a certain time of inactivity. Sometimes we work on confidential workbooks and forgot to close it every time we leave the work-space. This is where this quick excel tutorial will be helpful.
The idea is to save & close opened workbook if the user is not active for certain time. Most important part is the you can change your inactivity duration with your preferred time. Now lets follow the below procedure to automatically save & close workbook after certain time of inactivity.

Step 1: Click on the Developer tab (How to Add Developer Tab In Excel:
Step 2: Click On Visual Basic (Learn VBA Programming:
Step 3: Click “Insert” and then “Module”
Step 4: Write the code (If you need the code then subscribe to the channel and Fill up the “Request Form”:
)
Step 5: Click On “ThisWorkbook” from the project pane at the left side of the VBE (Visual Basic Editor)
Step 6: Paste the second part of the code.(If you need the code then subscribe to the channel and Fill up the “Request Form”:
)
Step 7: Save the workbook in .xlsm format
Step 8: Done. After 15 seconds of inactivity the workbook will be saved and closed.
PS. You can change the time duration by changing this line of the code: CloseTime = Now + TimeValue(“00:00:15”)

Thanks for watching.
#Automatic #Save&Close
————————————————————————————————————-
Support the channel with as low as $5

————————————————————————————————————-
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:
Advance Excel Tutorial:
Excel Tutorial for Beginners:
Excel Case:
Excel VBA Programming Course:

Social media:
Facebook:
Twitter:
Blogger:
Tumblr:
Instagram:
Hubpages:

Nguồn: https://valiosys.com

Xem thêm bài viết khác: https://valiosys.com/cong-nghe