Issues about making project references
 

Hi all,

I have some questions about making reference a workbook ("library")
containing codes to another workbooks ("apps").

1. If the apps workbook opens, I found that the library workbook also opens
automatically. How can I automatically hide the library workbook? Seems
there is no workbook.hide or workbook.visible command.

2. Both apps and library workbooks will be place in a server where multiple
users may access it automatically. Is it necessary to make the library
shareable? (because I don't want users see a message like "Library.xls is
open by another user...".

3. I wish that the library workbook will be closed automatically after the
last apps workbook is closed. How can I do that?

Thanks for your assitance.

Frederick Chow
Hong Kong.