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
Xem thêm Bài Viết:
- Hướng Dẫn Cài Đặt Và Crack 3DMAX 2018
- Descargar e Instalar Vehicle Tracking 2017 2018 y 2019
- AutoCAD 2018 – Create 2D Projects, Filling, and Text [COMPLETE]*
- Curso de AutoCAD 2018 – Aula 01/45 – Do Básico ao Avançado – Autocriativo
- Sketchup 2017 Full crack – Hướng dẫn tải và cài đặt SketchUp 2017 and full crack
Please send me the code. TQ