![]() VBA code 2: Auto save and close an Excel file after a certain idle time Sub SaveWork1()Ĥ. ![]() Then go on clicking Insert > module, and copy and paste below code into the Module window. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)Ī xCloseTime, "SaveWork1",, FalseĪ xCloseTime, "SaveWork1",, Trueģ. Private Sub Workbook_SheetActivate(ByVal Sh As Object) XTime = Application.InputBox("Please specify the idle time:", "KuTool For Excel", "00:00:20",, ,, , 2) VBA code 1: Auto save and close an Excel file after a certain idle time Dim xTime As String Then copy and paste below VBA code into the Code window. In the Microsoft Visual Basic for Applications window, please double click the ThisWorkbook in the right pane to open the Code window. ![]() Then press the Alt + F11 keys together to open the Microsoft Visual Basic for Applications window.Ģ. Open the workbook you need to make it auto saved and closed after a certain idle time. To auto save and close an Excel file after a certain idle time, please do as follows.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |