Closing a referenced workbook
 

Hi all,

I have several workbooks, all of which refer to a single Excel file
("referenced file") which contains common subroutines. I am considering the
possibility of closing the referenced file when a workbook is closed. I am
considering using the Workbook_BeforeClose event procedure, but the problem
is, at the time of closing a workbook, it still refers to that referenced
workbook and Excel just doesn't allow me to close it. Any workarounds?
Thanks for your advice in advance.

Frederick Chow