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.
 
Back
Top