Always open workbook and hide it

Microsoft Excel 2003 (full product)
March 12, 2010 at 11:47:55
Specs: Windows XP
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?

See More: Always open workbook and hide it

Report •

March 12, 2010 at 12:07:35
mod please move to office forum. thx

Report •
Related Solutions

Ask Question