Issues about making references to a workbook

F

Frederick Chow

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.
 

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

Issues about making project references 0
Ignoring a runtime error 1
populate a combobox based on unique values in another workbook 16
Hotkey in proper workbook 2
embedding pw's to master sheet & auto update w/out pw's 0
closing a workbook with a macro 2
Open four Wbooks, copy four columns from each to Master Wbook 16
Opening a list of Excel files and run a macro in each 17

Top