Personal Macro File Closing Error

  • Thread starter Thread starter Sue Kelley
  • Start date Start date
S

Sue Kelley

When I close my Personal macro file, I get the error
message, "This workbook is currently reference by another
workbook and cannot be closed". When I hit OK or close
the dialog box, Excel will close. It has no impact on the
file itself but is annoying. I'd like to correct
this but nothing I've seen addresses this issue.
 
Since Excel 97 a workbook that is referenced (under Tools, References in the
Visual Basic Editor) by another open workbook cannot be closed. If the
reference is unintentional you should check each open workbook for the
reference, remove it and save it.

If you're finding that all new workbooks have this reference it may be that
you're starting with a template file that has a reference. You'd have to
remove it from the template in that case.
 
You must log in or register to reply here.

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

Personal Macro 1
Need help on VBA excel macro and API to close an external application 0
Excel error message when closing Personal file. 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Closing Excel with Personal Macro Workbook 6
Macro to open, Update links, save and close workbooks 0
macro-file could not be found 2
Error message adaytum.xla when closing workbook in Excel 2003 1

Back
Top