Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tools key and add ins? | Excel Discussion (Misc queries) | |||
HELP! Where is the Tools tab?? | Excel Discussion (Misc queries) | |||
PA Tools Add In | Excel Discussion (Misc queries) | |||
Remove "Missing" reference in VB-Tools-References | Excel Programming | |||
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools | Excel Programming |