Let me give you some background information first. I have a workbook (Quote
Generator v3.xls) that references an add-in workbook (QG Add-In v3.xla). The
Quote Generator v3 workbook is password protected thus opened as read only
and the sales team uses it to produce product quotes. When the user saves a
quote they have to rename the Quote Generator v3.xls workbook (because it is
read only). For example, user saves the quote as CompanyABC Quote.xls onto
the server. The sales person may have several quotes open that reference the
QG Add-In v3.xla workbook and they may have their own other workbooks open
that don't reference anything.

My question is this. If the sales person closes all the quote workbooks
that reference the add-in workbook the add-in workbook remains open, why?

If nothing is referencing the add in workbook shouldn't it close
automatically?

Is there a way to have the add-in workbook close when no other workbooks are
referencing it?

Thanks in Advance!
--
Cheers,
Ryan