open 2 workbooks at once but keep one hidden

Microsoft Excel 2003 (full product)
March 15, 2010 at 09:52:59
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: open 2 workbooks at once but keep one hidden

Report •

#1
March 15, 2010 at 12:07:48
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.

Report •

#2
March 15, 2010 at 12:13:07
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....

Report •

#3
March 15, 2010 at 21:42:34
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)

Report •
Related Solutions


Ask Question