|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?