Returns a Boolean value that indicates whether or not the active document is currently saved in and connected to a shared workspace. Read-only Boolean.
expression.Connected
expression Required. An expression that returns a SharedWorkspace object.
Use the Disconnect method of the SharedWorkspace object to disconnect the local copy of the active document from the shared workspace. Use the RemoveDocument method to remove the document from the shared workspace.
The following example checks the Connected property to determine whether the active document is already saved in a shared workspace.
If ActiveWorkbook.SharedWorkspace.Connected Then
MsgBox "This document is already saved in a shared workspace."
End If