Error message when opening Excel

  • Thread starter Thread starter Michelle72
  • Start date Start date
M

Michelle72

I recently added macros to a spreadsheet to automate some of repetitive
steps. Now everytime I open Excel I get the error message: "This
workbook is currently referenced by another workbook and connot be
closed"

I have the same spreadsheet with the same macros on my computer with
Excel 97 and do not have this problem. The computer I have this
problem on is one at another location that has the XP version of Excel.
Any suggestions on how to get rid of this error message?

Any help would be greatly appreciated!

Thanks,
Michelle
 
Open your workbooks so you get the message again.

Then when you're in the VBE, take a look under Tools|References for each of the
open workbooks.

One of them will be pointing at that workbook's project (so it can't be
closed).

Your job will be to determine if that reference is set in error (so you can
remove it) or if it's ok to just uncheck.
 
Back
Top