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

SharedWorkspaceLink.ModifiedBy Property (Office)

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

Gets the name of the user who last modified the object. Read-only.

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


expression. ModifiedBy

expression A variable that represents a SharedWorkspaceLink object.

Return Value



For shared workspace objects, the ModifiedBy property returns the display name stored in the Name property of the SharedWorkspaceMember object.


The following example lists the links in a shared workspace site that were modified by a particular users.

    Dim swsLink As Office.SharedWorkspaceLink 
    Dim swsOwner As Office.SharedWorkspaceMember 
    Dim strMemberFiles As String 
    Dim strUser As String 
    strUser = "Nancy Davolio" 
    Set swsOwner = ActiveWorkbook.SharedWorkspace.Members(1) 
    For Each swsLink In ActiveWorkbook.SharedWorkspace.Links 
        If swsLink.ModifiedBy = strUser Then 
            strMemberlinks = strMemberlinks & swsLink.URL & vbCrLf 
        End If 
    MsgBox "These links were modified by " & _ 
        strUser & vbCrLf & strMemberlinks, _ 
        vbInformation + vbOKOnly, "Modified Links" 
    Set swsOwner = Nothing 
    Set swsLink = Nothing 

See also


SharedWorkspaceLink Object

Other resources

SharedWorkspaceLink Object Members

© 2018 Microsoft