Book1 Won't Close

[timbo1957]

Hi,

I have a problem which I just can't work out. From searching the net it seems that book1 has somehow become linked to something else but I don't know what.

If I open Excel 2010 book1 appears and if I double click the X top right of the screen to close Excel without doing anything I get this message -

This workbook is currently referenced by another workbook and cannot be closed.

Posts on internet suggest problems with an object in vba.

If I on Devloper and Visual Basic this is what I see in the projects window from the top -

atpvbaen.xls
Eurotool.xlam
The Personal.xls Workbook which has been there for months.
The Personal.xls workbook has References
Reference to atpvbaen.xlam
Reference to funcres.xlam
Reference to solver.xlam

Then there is Solver.XLAM

Follwed by VBAproject(Book1)
Within it there is
Sheet1
Sheet2
Sheet3
This Workbook

VBAProject (FUNCRES.XLAM)
Microsoft Excel Objects
Sheet1 (RES)
This Workbook

Modules
RibbonX_Code

'Entry point for RibbonX button click
Sub ShowATPDialog(control As IRibbonControl)
    Application.Run ("fDialog")
End Sub

'Callback for RibbonX button label
Sub GetATPLabel(control As IRibbonControl, ByRef label)
    label = ThisWorkbook.Sheets("RES").Range("A10").Value
End Sub

Under Tools References

Visual basic For Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Object Library

Are ticked.

I have taken a screen shot and attached.

Any help much appreciated.

Excel will close but not properly.