Workbook.CheckIn (Excel)

Returns a workbook from a local computer to a server, and sets the local workbook to read-only so that it cannot be edited locally. Calling this method will also close the workbook.

CheckIn (SaveChanges, Comments, MakePublic)

 If Workbooks(strWkbCheckIn).CanCheckIn = True Then 
 Workbooks(strWkbCheckIn).CheckIn 
 MsgBox strWkbCheckIn & " has been checked in." 
 Else 
 MsgBox "This file cannot be checked in " & _ 
 "at this time. Please try again later." 
 End If

Arguments

Optional arguments

The following arguments are optional

SaveChanges - True saves changes and checks in the document. False returns the document to a checked-in status without saving revisions

Comments (String) - Allows the user to enter check-in comments for the revision of the workbook being checked in (applies only if SaveChanges equals True).

MakePublic - True allows the user to publish the workbook after it has been checked in. This submits the workbook for the approval process, which can eventually result in a version of the workbook being published to users with read-only rights to the workbook (applies only if SaveChanges equals True)