This works absolutely beautifully. I think I may be a little dense. How do I duplicate it, I could only find this VBA code in the workbook:

Sub VBAReferences()

  Dim Ref As Object
  Dim Refs As Object
  Dim VBproj As Object
  
    Set VBproj = ThisWorkbook.VBProject
    Set Refs = VBproj.References
    
      For Each Ref In Refs
        N = Ref.Name
        D = Ref.Description
        P = Ref.FullPath
        T = Ref.Type
      Next Ref
        
End Sub


How do I duplicate your drop downs? I can't see how to set them the way you have. Sorry to not get it...

Thanks.

Veronica