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

Please Login or Register  to view this content.

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.

[shg]

Where is Book1 stored?

[timbo1957]

Pass. It opens on its own every time Excel opens.

[shg]

Pass?

Does it appear in View > Switch Windows?

[timbo1957]

Yes it does appear in View > Switch Windows.

[shg]

Is there the workbook Book.xltx in the XLSTART folder?

[timbo1957]

No just the Personal workbook in the XLSTART folder.

[shg]

How about the other XLSTART folder?

What happens if you uninstall all add-ins and delete or rename Personal?

[timbo1957]

Hi Shg,

I have copied the personal.xls workbook to a memory stick and deleted the personal.xls workbook from the Roaming\Microsoft Office\Excel\Xlstart folder and now that has cured the problem.

There is nothing in the other xlstart folder in the Office 14 folder.

How do I get my file full of macros back into the pc?

[shg]

Just to ask the obvious: You don't have any code in Personal that opens another workbook, do you?

Copy Personal back to the XLSTART folder and try again.