Linking Workbooks

Hi,

I've been wrestling with this issue for a while, does anyone have any good ideas for me. I have 2 workbooks, one of which is a working document and the other of which is just a master data file that feeds lookups, drop down boxes etc in the working doc. I need to link these workbooks in order that when someone opens the working doc the master data will automatically be available. I have tried macros but every time it runs the drop down boxes in the working doc become static and I have tried leaving the master data file open in the system but can't get this to work properly as it always opens in session to me on my desktop and therefore is not available to others even when I make it a shared doc. Does anyone have any flashes of inspiration for me? I'm at a loss.

Hi TMShucks,

I have done this already and I'm not concerned about them changing data etc I just don't want them to have to open both workbooks manually in order to get them to work. I want the end user just to have to open the working doc and the info from the master data doc to be automatically available.

Have you thought of a workbook event to open the master workbook.

Go Into your VBA screen (Alt + F11) then in the Project Window double click where it says ThisWorkBook then from the First Drop Down (Object) select Workbook and it will display

Private Sub Workbook_Open()

Add the code to open the master

workbooks.Open "Path and name of Master.xls"

That will always open the master