Table of contents
Collapse the table of content
Expand the table of content

SharedWorkspace.Disconnect Method (Office)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Disconnects the local copy of the active document from the shared workspace site.

Note Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.


expression. Disconnect

expression A variable that represents a SharedWorkspace object.


Use the Disconnect method to detach the local copy of the active document from the shared workspace site. This method leaves the shared document on the server; however, the local copy will no longer be synchronized with the shared copy and will no longer benefit from the other collaboration features of the shared workspace. Use the RemoveDocument method to remove the shared document from the server.


The following example determines whether the active document is connected to a shared workspace site, then offers the user the option of disconnecting it.

   Dim r As Long 
    If ActiveWorkbook.SharedWorkspace.Connected Then 
        r = MsgBox("Are you sure you want to disconnect this document?", _ 
            vbQuestion + vbOKCancel, "Are you sure?") 
        If r = vbOK Then 
            MsgBox "The document has been disconnected.", _ 
                vbInformation + vbOKOnly, "Disconnected" 
            MsgBox "Disconnect canceled.", _ 
                vbInformation + vbOKOnly, "Still Connected" 
        End If 
        MsgBox "The active document is not connected to a shared workspace.", _ 
            vbInformation + vbOKOnly, "Not Connected" 
    End If 

See also


SharedWorkspace Object

Other resources

SharedWorkspace Object Members

© 2018 Microsoft