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

Excel Protection 2
Macros in Excel 2007 3
Error msg on opening excel workbook 1
Excel Excel spreadsheets opening at top instead of bottom. 4
corrupted shared excel workbook 1
Disable Macro Alert 2
XLSM File Will Not Save Macros in Quick Access Toolbar 4
error msg on opening excel workbook 2

Back
Top