The title of your posting was "Lost XLQuery Refference". this may not be a
macro. Go to on worksheet menu Files _ Propertenies - Contents. See if it
is a named range. If it is run this macro

Sub removename()

For Each myname In ThisWorkbook.Names
yesno = MsgBox("Remove? " & myname.Name & " Range is : " & myname,
vbYesNo)
If yesno = vbYes Then
myname.Delete
End If
Next myname

End Sub



"Mervyn Thomas" wrote:

Everytime I open a workbook it complains about a missing reference to a
macro which was originally set to run when the workbook opened. I cannot
find this macro in the VB editor for the file or where it is referenced from
in order to kill it? Any ideas?