Excel.Workbook.CanCheckIn.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.CanCheckIn method (Excel)	vbaxl10.chm199205	vbaxl10.chm199205	Excel.Workbook.CanCheckIn	17f7cbdd-0ce0-8e3a-46f3-cb6dafaaa40a	05/29/2019	medium

Workbook.CanCheckIn method (Excel)

True if Microsoft Excel can check in a specified workbook to a server. Read/write Boolean.

Syntax

expression.CanCheckIn

expression A variable that represents a Workbook object.

Return value

Boolean

Example

This example checks the server to see if the specified workbook can be checked in. If it can be, it saves and closes the workbook and checks it back into the server.

Sub CheckInOut(strWkbCheckIn As String) 
 
 ' Determine if workbook can be checked in. 
 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 
 
End Sub

[!includeSupport and feedback]