Workbook currently referenced by another workbook

K

Keith Larsen

I get the following warning everytime that I open Excel:

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

If anyone has any ideas I would appreciate your
suggestions.

Thank you,

Keith
 
T

Tom Ogilvy

Another open workbook has a reference to this workbook in Tools=>References
in the VBE. As stated, as long as that reference exists and the other
workbook is open, this workbook can not be closed. Close the other
workbook first, or remove the reference.

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
How to create absolue path link to another workbook (Excel 2003) 1
Returning info from another workbook 1
Error? Message 2
Close form automatically upon opening workbook 2
Lost XLQuery reference 3
Macro to Copy From One Workbook To Another 3
Error message on start-up 3

Top