VBA: Tools -> Reference

[Guest]

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]

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.

 

[Dave Peterson]

All this takes place in the VBE--not excel.

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.

 

[Guest]

Awesome! Thanks!!!

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.