Workbook 1 uses data (for a dropdown) from Workbook 2. In order for workbook 1 to be able to pull the data, both workbooks need to be open. Is there some setting to tell Excel, "When workbook 1 is opened, also open workbook 2 and hide it." Just like what happens to the Personal.xls file...Maybe a macro?
Workbook 1 is saved on the network and multiple people will use it so this setting needs to work regardless of what computer is used. Any ideas?
First this sounds like the job that would be more suited for a data base (MS Access, etc) rather than a spread sheet. If you put the data on a second sheet of the same workbook (or a copy of it) rather than on a separate workbook, it would open at the same time. I'm not sure if you could actually hide the tab, but you could lock the sheet if you do not want the data changed.
That could work however I have over a hundred books linking to one master book. If I need to change something, I just change it once on the master. If I move this data onto sheets within the books, then I will have to open each book individually and make the change....
Sorry, I know of no way, but I am not very up on Macros, I have only used a few 'stock' ones.
I would recommend you post this question over on the 'Office Software' forum (Unless a moderator can move it)
Ad Choices