VBA: Tools - Reference
 

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!

VBA: Tools - Reference
 

Awesome! Thanks!!!

"Dave Peterson" wrote:

Hit ctrl-r to see the projects for each workbook.
Select the project that you want to refer to.
hit F4 to see it's properties
change that (name) property to something unique--don't use VBAProject

Save that workbook with its new project name.

Try adding the reference.

CinqueTerra wrote:

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!

--

Dave Peterson