Edit

SharedWorkspaceLink.ModifiedBy property (Office)

  • Article

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.

Syntax

expression.ModifiedBy

expression A variable that represents a SharedWorkspaceLink object.

Return value

String

Remarks

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

Example

The following example lists the links in a shared workspace site that were modified by 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 
    Next 
    MsgBox "These links were modified by " & _ 
        strUser & vbCrLf & strMemberlinks, _ 
        vbInformation + vbOKOnly, "Modified Links" 
    Set swsOwner = Nothing 
    Set swsLink = Nothing

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.