I have a spreadsheet (A) that links to another spreadsheet (B), if i open
just (A) then all my linked cells are #Value errors, so i need to open (B) as
well.

Problem is, its actually my users who will be doing this and unfortunately
this task is a bit difficult for them (don't ask!!!!)

So i have written some code in the Workbook_Open() event of (A) to open (B).
Then they see another spreadsheet is open and they try to close it -
problem!!!

So i want to open (B) and then hide it in some way so it doesn't show on
their toolbars, in the window etc, but i can't find the code to do this.

The only other problem here is that some users use spreadsheet (B) for other
purposes and therefore may already have it open, therefore i would like some
sort of STOP i.e. a message that says, you already have (B) open, you cannot
continue until you have saved and closed (B) which then stops the macro and
closes (A) as well.

Thanks for the help.
Emma