I have a two workbooks. Whenever one is opened, I need the other to be open.
I know it is possible to do this by creating a reference within the VBA the
first workbook. I have tried going into Tools -> Reference and selecting the
second workbook, but this gives an error.

Error: Name conflicts with existing module, project or object library.

Thanks, in advance, for any help you might give me!