Need to insert url on PNG files inside the spreadsheet

Marcelo675 

The question isn't clear to me. Are you looking for a one-by-one solution or are you looking for a macro to do them for you? In case of a one-by-one solution: right-click on the item -> link -> add hyperlink (at the bottom). Or if you don't mind shortcuts: select the item and hit ctrl + k.

VBA

In case you're looking for a solution through VBA, you could design a form like the one above. The code for the example form could be:

Private Sub CancelButton_Click()
    Unload Me
End Sub

Private Sub ConfirmButton_Click()
    ' Get the row select
    SelectedRange = Selection.Address
    
    ' Go over all rows
    For Each Cell In Range(SelectedRange)
        Hyperlink = UrlField.Value
        
        ' Check if the checkbox was checked to append the filename
        If AppendBox.Value = True Then
            ' Add the current cell value to the hyerlink
            Hyperlink = Hyperlink + Cell.Value
        End If
            
        ' Set the HyperLink
        ActiveSheet.Hyperlinks.Add Range(Cell.Address), Address:=Hyperlink
    Next Cell
End Sub

Hopefully, this answers your question.