View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Linked Workbooks

You create a reference by going into tools=References in the VBE and
checking a box next to the project name of the workbook you can't close.
Find the workbook where you have done that and uncheck it.

--
Regards,
Tom Ogilvy


" wrote:

For an unknown reason, whenever I try to close a workbook that I have
been building, I now get the message, "This workbook is currently
referenced by another workbook and cannot be closed." I don't have any
other workbooks, so I'm not sure what is causing the problem. I may
have done something inadvertantly during development. Does anyone know
how to track this problem or to resolve it?

Thanks,

Terry in Kalamazoo