Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing VBA Project References for non-VBA commands | Excel Discussion (Misc queries) | |||
VB Project References | Excel Discussion (Misc queries) | |||
Issues about making references to a workbook | Excel Programming | |||
Project One - Nearly done - Protection issues | Excel Programming | |||
code to check for project references in VBA | Excel Programming |