Trouble with signature macro

[vman5781]

With the help of the forum I have a signature macro that had been working fine, but recently has been putting the signature of the person that last opens it into the file (suppose to be the signature of the person that performs the recon)

Below is the code that I have ben using (work sheet has 20 tabs, 1 for each employee) Signature for each employee saved on there own "g" drive

Any help would be appreciated to have when a signature is inserted, it locks it so it doesn't change

Sub SIGN()

' SIGN Macro
    Dim pictureSource As String
    pictureSource = "g:\signature\signature.JPG"
        
    Dim outputCell As String
    outputCell = "ActiveCell"
    
    Dim ws As Worksheet
    Set ws = ActiveSheet
    
    With ws.Pictures.Insert(pictureSource)
    
        .ShapeRange.LockAspectRatio = msoFalse
        .Left = ActiveCell.Left
        .Top = ActiveCell.Top
        .Width = ActiveCell.Width
        .Height = ActiveCell.Height
        
        
    End With

End Sub

Thank you

John

 

[rlv01]

The code as-is seems to work fine, but which image gets inserted is entirely dependent on how drive letter g: is mapped, so if you are not getting the current user's .jpg, that's where I would start looking. The whole strategy of "locking" a signature graphic that you are pasting onto a worksheet seems dubious and I don't understand what you are doing enough to comment. Also, the code only seems to add signature images. It never removes them so after awhile you will have a bunch of images in the worksheet, which seems like a problem.