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

Novell server full path names of VBA references 8
All Workbook Saved except This Workbook - Part2 3
Macro Location Problem 1
Any library issues when giving XL2003 wkbk to XL2000/2002 users? 2
Checking the existence of a reference workbook 4
Close a workbook 4
Automatically closing workbook 1
Refrence a workbook procedure from another workbook 3

Top